Hi
Have a look at this site
http://www.mcgimpsey.com/excel/lookuppics.html
HTH
John
"Looping through" wrote in message
...
Does anyone have a code that will change a bitmap picture within a form based
on a cell reference number in the workbook?

When commandbutton 1 is clicked or pushed check the value of cell a3. Based
on the returned value change the image reference to match. I have bitmap
pictures hiidden within the workbook and they are named.

IE if A3=1, show picture1 within image1 block. If A3=2 show picture2 within
image1 block and so on.

Any Help is appreciated.
Thanks
Pete