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

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
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.
 
Upvote 0

Forum statistics

Threads
1,214,792
Messages
6,121,612
Members
449,038
Latest member
apwr

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