Fetching a DblClick over a SpinButton is possible?

[Bub]

Hello, as the DblClick Event is apparently not defined for a SpinButton in Excel 2003, I was wondering if some relatively simple code exists or trick exists to do so? I'd like to set the reset the spinvalue to the min value or max value when double clicking over the corresponding arrows of the spin.
Many Thanks In Advance. PS: My first post!

 

[RoryA]

I think there is a good reason for there not being a double-click event: it would make it very difficult to click quickly up or down the scale, which a user might want to do!
If you really wanted it, you could probably store the time and spin direction in variables outside the spinup and spindown events and then within each check the direction and current time - if the direction is the same as the stored value and the time is within a short interval of the last time, then run your 'double-click' code, otherwise do the normal spin code.

 

[Bub]

Looks to me to be a reasonable and appealing work-around. Thank you Rory for this fast reply. Much appreciated.
Alain (alias Bub)