Recent content by brucend75

Thanks, Modest. I'd tried that. I tried it again with exactly your code. Same problem. I couldn't click on the stop-timer button until the timer ran out. (the stop-timer button sets a public boolean to false; a check for that is in the loop in the timer code and breaks out of the loop to do...

When I click on a command button, I want to 1) call a user-defined function, then 2) Run a procedure. The function displays text on an unbound textbox. The procedure creates a 20 second timer. I've tried to embed the procedure call in the function, but then nothing else on the form can be...

Never mind. Solved the problem.

I have been working to create a timer that counts up to 20, with a DIY progress meter displaying the progress. Have got all to work great, but now need a way to interrupt the procedure to stop the timer in mid process. Am using DoEvents to update progress meter throughout the process (thanks...

Thanks, Tim!!!! Worked like a charm.

Hello, I am trying to create a timer that, when pressed, counts seconds upward from 0 to 20, based on second(now()). In my test mode, I have my vba code as a procedure activated by a command button, and I want the seconds to display in a textbox. I'm using a Do While loop to accomplish...