spinner counters in excel

  cfcnick 15:50 06 Jan 04
Locked

how can i program a macro in excel to tab a spinner counter?

thanx

  VoG II 16:01 06 Jan 04

Not quite sure what you are asking.

If you right click the spinner and select Format Control you can set a linked cell on the Control tab.

  cfcnick 16:07 06 Jan 04

yes i understand this; but how can i record a macro that when run will click on the spinner to change the value in the linked cell?

i know it may sound not worth doing but it is neccasary in a spreadsheet system i am making.

  VoG II 16:12 06 Jan 04

You can't record a macro to imitate the action of clicking the spinner. What you can do is to change the value in the linked cell like:

Sub spin()

Sheets("Sheet1").Range("B2").Value = Sheets("Sheet1").Range("B2").Value + 1

End Sub

  cfcnick 16:18 06 Jan 04

oh well. il see what i can do with that!!

thanks very much

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Method Studios' title sequence for BBC series Taboo is truly unsettling

Best Pages for iOS tips | How to use Pages for iPad & iPhone: 6 simple tips to get more out of…