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

Hi Pete,

I would suggest you put all pictures in the form.
And depanding on the value in A3 you make the corresponding picture
visible.
You do not metion how many pictures are involved.

HTH,

Wouter

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