View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
downward spiral downward spiral is offline
external usenet poster
 
Posts: 1
Default One spinner that controls whichever cell I select

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.