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.

--
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

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



"Tom Ogilvy" wrote in message
...
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

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.


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Hélder Lima" wrote in message
...
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



"Tom Ogilvy" wrote in message
...
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