I have a worksheet with multiple numeric values which are changed very
frequently. I would like to be able to just make one spinner to control
'selected cell' or 'highlighted cell'. Is this possible? I understand I can
link the spinner to (example) A2 but is there a code that means 'selected
cell' where I could just click on cell A3 or A4 and use the spinner to change
just A3 and just A4?

If this is not possible I will need to make a separate spinner next to each
and every number field on my worksheet which seems monotonous. If this is the
method you would suggest, how could I just create one row with multiple
spinners and have that one row copied downward till the end of the document.
I tried copy + paste but the spinners are still controlling the cell from the
area I copied and I have to re-edit the linked cell for all pasted spinners.

All is possible through Excel!! just kidding but here you go:

Private Sub SpinButton1_SpinDown()
ActiveCell.Value = ActiveCell.Value - 1
End Sub

Private Sub SpinButton1_SpinUp()
ActiveCell.Value = ActiveCell.Value + 1
End Sub


--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"downward spiral" wrote:

I have a worksheet with multiple numeric values which are changed very
frequently. I would like to be able to just make one spinner to control
'selected cell' or 'highlighted cell'. Is this possible? I understand I can
link the spinner to (example) A2 but is there a code that means 'selected
cell' where I could just click on cell A3 or A4 and use the spinner to change
just A3 and just A4?

If this is not possible I will need to make a separate spinner next to each
and every number field on my worksheet which seems monotonous. If this is the
method you would suggest, how could I just create one row with multiple
spinners and have that one row copied downward till the end of the document.
I tried copy + paste but the spinners are still controlling the cell from the
area I copied and I have to re-edit the linked cell for all pasted spinners.

Oh my god, finally! Thank you so much John Bundy! I've been asking all over
the internet and you're the only one that knew.

"John Bundy" wrote:

All is possible through Excel!! just kidding but here you go:

Private Sub SpinButton1_SpinDown()
ActiveCell.Value = ActiveCell.Value - 1
End Sub

Private Sub SpinButton1_SpinUp()
ActiveCell.Value = ActiveCell.Value + 1
End Sub


--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"downward spiral" wrote:

I have a worksheet with multiple numeric values which are changed very
frequently. I would like to be able to just make one spinner to control
'selected cell' or 'highlighted cell'. Is this possible? I understand I can
link the spinner to (example) A2 but is there a code that means 'selected
cell' where I could just click on cell A3 or A4 and use the spinner to change
just A3 and just A4?

If this is not possible I will need to make a separate spinner next to each
and every number field on my worksheet which seems monotonous. If this is the
method you would suggest, how could I just create one row with multiple
spinners and have that one row copied downward till the end of the document.
I tried copy + paste but the spinners are still controlling the cell from the
area I copied and I have to re-edit the linked cell for all pasted spinners.