Spin Button Using Multiple Active Cells

I have an excel sheet with numerous columns/rows of data. I want to be able to adjust multiple active cells simultaneously using either a Button or Spin Button.

Adjusting a single cell is not trivial, but it is adjusting multiple active cells (range of which can/will change) that I have reached my dilemma.

Here is what I'm using to adjust a single active cell with a Spin Button:

Please Login or Register  to view this content.

Any suggestions? Is using multiple (user chosen) active cells even possible?

Thanks

Yes, I was and it was not working. What specific spin button are you using, and what version of excel?

ActiveX spin button and Excel 2010. See attached. Multiple cells will be selected when you open it, just click the spin button.

Also, not sure why you have this line of code. It's not necessary in this situation, but I left your code exactly as is in this file.

Please Login or Register  to view this content.

Is not working in Office 2013 or 2014. Single cell selection and changing works, but not multiple (same as I described in the initial post).

Any idea if it's a version difference? Any way to run Excel as a previous version?

Or, what has changed in the programming from 2010 to 2013/2014 to cause this not to work?

I opened this on my other machine that runs Excel 2013 and the only problem I had was an invalid call error on this line

Please Login or Register  to view this content.

When I commented it out, everything ran fine.

Exactly what steps are you taking to select multiple cells? What OS are you using?

I was either dragging to select cells, or using shift-click to highlight multiple cells and that does not work. However, I do now see if I use Control-click for multiple cells it does work.

My dilemma now is that it changes the entire selection to the same number. It does not simply add 1 to each value.

I.e. row with: 5 4 6
Does not become: 6 5 7

I did some further tests on this and found that some selections work but some do not. I can't see what is the difference. But I solved it with this:

Please Login or Register  to view this content.

Edit: This will also solve your problem of all cells being set to the same number.

Thanks 6StringJazzer, that code works just as I had hoped.

Repped!