Thread: Spin Button
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Spin Button

Private Sub SpinButton1_Change()
varr = Array("image1", "image2", "image3")
sStr = "C:\My Pictures\" & varr(lbound(varr,1) + _
spinbutton1.value-1) & ".gif"
' now do what

End Sub

Regards,
Tom Ogilvy


Andrew wrote in message
...
How do I toggle through a group of images? Similar to
changing TV channels. I can do this with numbers, no
problem, but images? Any suggestions where to start?

Private Sub SpinButton1_Change()

End Sub

Thank you.