Change image using scroll bar

[andrewmaroul]

I would like to be able to change the image in an excel file based on the value that is generated from a form scroll bar.

Specifically, I have 100 images that I want to correspond to numbers 1-100 in a cell. I know how to display the value of the scroll bar on to a specific cell but I cannot make it so the image automatically updates as the values in scroll bar change.

I would like the minute I change from two adjacent values (e.g. 49 to 50) for the image to automatically refresh.

I have been trying to do this by loading the images from a folder on an active x image box with the following VBA code:

Please Login or Register  to view this content.

The images change when I manually type in and enter a new value in excel, but i would like the image to change as I scroll the scroll bar.

Any input would be greatly appreciated.

[OnErrorGoto0]

Your profile says you are using 2011, but you mention ActiveX controls which do not work on Macs, so which version are you actually using?

Have you tried moving the code to a routine that you assign to the scroll bar as a macro?

[andrewmaroul]

I was doing this on Excel 2010 for Windows.

I am sorry for my lack of VBA but how do I move the to a routine that I assign to the scroll bar as a macro? Do I use the same code I posted but geared towards the scroll bar?

[andrewmaroul]

I was doing this on Excel 2010 for Windows.

I am sorry for my lack of VBA but how do I move the to a routine that I assign to the scroll bar as a macro? Do I use the same code I posted but geared towards the scroll bar?

Also, no need to answer this, but any idea how I would go about doing this on excel for mac where there is no active x support?

Thank you in advance