Choose picture to display

  • Thread starter Thread starter Tomas Stroem
  • Start date Start date
T

Tomas Stroem

Hi,

I am about to make a form from data in an excel sheet, simple, until the
demand came that, depending on some data in this sheet, a specific picture is
supposed to be dislplayed in the form.

My guess is that a macro is the best way to make this happen but right now I
dont see the way, can somebody give an idéa?

grateful for all suggestions
 
If you are looking at Userform; check the properties window of User form and
browse a picture for the Picture property.

If you are looking at inserting a picture in worksheet. Check Insert..menu

If this post helps click Yes
 
I think we need some more information. When you say "form", do you mean a
UserForm or a worksheet made to look like a form? Are you talking about
having several pictures and having them automatically change as the data
changes in some way? If so, tell us what the conditions are that determine
what pictures to use. Also, to make it easier on you for implementing any
code we give you, tell us the names of your picture files, the directory
they are kept in and which picture file goes with which data condition.
 
Sorry,

I mean a sheet that loks like a form, feed from the sheet with data, one of
the pieces of information needed is the picture that I want to insert at a
specific location in this form sheet.

The user will, through filters, find the set of information suitable for
what shall be accomplished. In a cell they will enteyr the number for this
information set, which I will use to populate the form sheet. Then they will
print the now created sheet to use as instructions in next operation. One of
the pieces of information is the picture that I need to insert-

The data will be several hundred rows where each row will fill the form
sheet. -number of pictures i far less, perhaps 20. I will create an
indentifier to choose picture from depending on three different pieces of
information in the database. This will be numbers from 1-20. I plan to save
the pictures in the same directory as the worksheet containing data. Name
will be "pic 1.jpg" ....

Hope this gives a better idea...
 
If the pictures weren't too large (in bytes), then I'd just put them all in the
same location--where they need to be to be printed.

Then instead of loading them from the folder, just show the one you want (and
hide the others).

worksheets("somesheetname").pictures("Pict001").visible = true

kind of thing.
 
Back
Top