Spinner - Control incremental change

rodneeeeo

New Member
Joined
Jan 25, 2005
Messages
4
I've created a spinner but can't control the increment even though I've indicated 1. For example, my Min/Max values are 1 & 12. If I increase, the spinner shuffles to 12 quickly and vice versa. I can't get the spiner to stop on any number other than 1 or 12.

Anyone have any ideas?
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Tazguy37

MrExcel MVP
Joined
May 28, 2004
Messages
4,237
Delay is just the delay (in milliseconds) before another event can take place if a spinbutton event occurs. If the delay is really low, though, you could generate a lot of events with (seeemingly) a single click. You click the spinner, and before you can release the mouse, more events are generated, taking the button to its min (or max) value.

I've seen this same thing before, but it was from the smallchange property being set incorrectly.
 

Forum statistics

Threads
1,147,507
Messages
5,741,566
Members
423,667
Latest member
Kai_357

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top