Speed of SpinButton
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.
--
Regards,
Tom Ogilvy
"Hélder Lima" wrote in message
...
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
|