Image Control

L

Looping through

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
 
W

Wouter HM

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Picture Form Help 1
Image Control - MouseMove Event 1
Problem with SET & REF function 0
Adding an image to an Image control 1
Place picture in Excel cell 0
Excel Function not Evaluating to a Result 1
user form image 8
Changing what is displayed in an image control programatically 2

Top