Click and hold event on a form control spinner breaks my code

Hello mansfin,

Welcome to the Forum!

With everything linked together when the values change, what did you expect to happen?

If you explain what you want to achieve then a workable solution can probably be found.

Hard to say what's happening. Can we take a look at your workbook?

I should have explained that if the user increments one of the spinners up and the one of the cell values rounded to to the nearest tenth is equal to 10, then all of the cell values increase from the click of the spinner. After that happens, the code from the macro that's attached to the spinner executes and automatically adjusts the spinner down one increment, so the user ends right where he/she started before clicking the spinner.

However, when the user clicks and holds the spinner, the linked cell increments multiple times before the macro that is attached to the spinner is executed.

I uploaded my workbook. First, increase the "Offers a variety of products" spinner by 20 increments (there is a 20 increment limit on the spinners). This will allow the spinners on the left to surpass 10.0. Next, increase "Clearly explains the programs and offerings they provide" spinner by 12 increments. Now the linked cell value is at 10.0. Next, click on it one more time. You can see the other linked cells increase, but then the assigned macro executes and the values go back down to the starting value. This is normal functionality.

Now if you click and hold the "Clearly explains the programs and offerings they provide" spinner, then a problem arises. The spinner increments even though the cell value is already at 10.0, which is undesired. Any ideas? I'm trying to avoid using the ActiveX spinners.

Hello mansfin,

So have I. Keep trying.

The macro is only executed when you release the spinbutton, but the spinbutton code is executed immediately and repeated as long as you hold the botton. So there's your problem.
Guess you should move control entirely to the macro. Means that you would not link the spinbuttons to a cell but have the macro assign the spinbutton values to these cells.
Should be something like

Please Login or Register  to view this content.

Tried this myself but ran into some more required adjustments. So still working on it. But this sure will be easier for you being more familiar to the code

Extra adjustements needed come from - afaiks now - this line

Please Login or Register  to view this content.

So you would also need an alternative to determine the rownumber. Probably something like this

Please Login or Register  to view this content.

You're welcome. Thx for the rep
If this solved your problem, pls mark the thread [Solved] (see Thread Tools).

BTW: the --() function is a so called double unary operator. This translates TRUEs and FALSEs to their numeric values 1 and 0 resp.