spinner counters in excel

  cfcnick 15:50 06 Jan 2004
Locked

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

thanx

  VoG II 16:01 06 Jan 2004

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 2004

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 2004

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 2004

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

thanks very much

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

Elsewhere on IDG sites

Best Black Friday Deals 2017

How modern book design was influenced by illustrated manuscripts

Best Black Friday Apple Deals 2017

Les meilleurs logiciels de montage vidéo gratuits (en 2017)