Speed of SpinButton

  • Thread starter Thread starter Hélder Lima
  • Start date Start date
H

Hélder Lima

I am using Excel 2000 and i have an SpinButton in an application. It
increases/decreases from 1 to 65000 with .value=1 and i have a label showing
the value. How can i do to accelerate the speed of the increase/decrease
after a while ?

Thanks
 
Look at the Delay property:

from help

The Delay property affects the amount of time between consecutive SpinUp,
SpinDown, and Change events generated when the user clicks and holds down a
button on a SpinButton or ScrollBar. The first event occurs immediately. The
delay to the second occurrence of the event is five times the value of the
specified Delay. This initial lag makes it easy to generate a single event
rather than a stream of events.
After the initial lag, the interval between events is the value specified
for Delay.

The default value of Delay is 50 milliseconds. This means the object
initiates the first event after 250 milliseconds (5 times the specified
value) and initiates each subsequent event after 50 milliseconds.
 
Thanks Tom
I have tried change the Delay property but didn't work so well.
Actually i want this:
- Initially the value is 1
- the user press the up button and continuous pressing it
- after a while the value is added not 1 by 1, but 10 by 10
- if the user continuos to press, the value is added 100 by 100
- if the user stop to press the up button and press it again, the process
start again.

Thanks
 
I spent a long time looking at this. I can't see any way of doing what you
want.
If there was an event called SpinButton_Release then you could check the
amount of time passed while holding the button down.
After, say, 3 seconds you could increase the value in SmallChange property.
 
Back
Top