I want to increase Date until button is released...

[hollifd]

I have a form with a textbox on it. Under the textbox there is a button that says ">" which stands for increase Date. When I press the button, I want to increase the Date in the textbox 1 day at a time until the button is released. How do I do that in VBA?

Thanks,

David

 

[VicRauch]

I think it would be a combination of MouseDown, Timer, and MouseUp events.
When you experience a mousedown, set the time interval and have the timer event increase the date by a day until the mouseup event, then stop the timer event by setting the timer interval to 0. You would control the speed of the date increase by the value of the timer interval. One second would be a value of 100 or 1000. I always have to test it.
HTH,

 

[hollifd]

Thanks VicRauch,

But while I was waiting for your answer, I noticed the "Auto Repeat" setting for my button. I never noticed that option before but it will repeat the code in the button until the button is released.

Thanks,

David

 

[VicRauch]

Thanks David, I had never seen that before either.