ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Spin Button (https://www.excelbanter.com/excel-programming/271973-spin-button.html)

Andrew[_14_]

Spin Button
 
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.

Tom Ogilvy

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.





All times are GMT +1. The time now is 10:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com