Howdy,
Well I'm sure you could do it an easier way but this is how I did it....
First I found an SRM chart ranging in colour from 1-30. Then I did a crop and made a seperate image with the same dimensions and named them 1-30.
Next I inserted each image into the spreadsheet but I placed them ontop of each other exactly. This way I could hide 29 of the images that I don't want to show, and only show the one image (srm colour) I wanted.
Now I wrote a little visual basic code to get the images to show/hide by using the
image.visible=true or
image.visible=false. Hopefully you know a little Visual Basic to get you by. Now the trick was to get the cell srm number into my code from the spreadsheet. The only way I got it to work was create a list box and link the cell to the combobox. Then use the combobox1.value in my code. Now what I did was create a bunch of nested if statements like the example below:
If Combobox1.value <=1 Then
image1.visible = True
image2.visible = false
image2.visible = false
ect....ect... until 30 is reached
else If Combobox1.value <=2 Then
Image1.visible = false
Image2.visible = true
Image3.visible = false
ect....ect.... until 30 is reached
else if Combobox1.value <=3 then
BLAH BLAH BLAH all the way to 30
end if
Hopefully this helps you. I'm sure you can figure out an easier way to get it to work.
If you have any questions feel free to contact me by email at
[email protected]
Best of Luck,
Grimmy