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.

What is Amazon Go and will it come to the UK? The store without checkouts or queues

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

Why ecommerce hasn't taken off on social media

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…