select a picture in a spreadsheet

[mortphil]

Hi everyone,

I would like to select a picture that is in my spreadsheet say Range("A10") and then display it a userform.

to select the picture I tried this:

Please Login or Register  to view this content.

obviously it did not work, I never used picture in Excel. Would you know how to do this?

Thanks for your time,
-Phil

[Bernie Deitrick]

It's a little more complicated than that - requires a lot of API calls... In your userform's codemodule, assuming you have an image control named Image1:

Please Login or Register  to view this content.

and in a standard codemodule - assuming you have a 32 bit operating system:

Please Login or Register  to view this content.

[mortphil]

thanks Bernie.

That works. Maybe I should rethink my spreadsheet.

I made myself a quiz. In col B I have QUESTIONS and in col C I have the ANSWER. I randomly pick a QUESTION, display it in a userform. Once I answered the Question, I Display the corresponding answer.
I wanted to include pictures in my ANSWER field, because some formula are hard to write in text. But I cannot store picture in Excel range and display it easily as I would with TEXT.

Thanks for your post,
-Phil

[Bernie Deitrick]

There are all sorts of better ways - store the picture(s) in a certain folder, and store the name in a cell, and show the picture if the question's corresponding picture name cell is not blank.....

[mortphil]

Thanks Bernie,

At the moment this is sort of what I do.
If the corresponding answer is not blank, I take the value and display it, in a userform or a message box.

I thought of saving the picture on the hard disk and indexing them, putting the path in the Answer cell to open it. but I would like the pictures to be within the file. So that it would work on another computer. I realize it's a bit complex.

would you know how to open a picture in a userform if I have the path that leads to that picture save in the answer Range ?

[Bernie Deitrick]

The easiest solution is to put all your pictures into the userform - in separate image controls, one per picture - and only set the visible property to true for the one you want to show, and then set it back to false when you want to show another picture. You can stack the image controls on top of one another, and when all are visible = false the only one with visible = true will show.

[mortphil]

I see, Would it be heavy. I mean the volume of pictures to keep within the userform ?

I will try that.

Thanks for your help

[Bernie Deitrick]

Make sure you use small jpeg files, sized to the size of the image control - I'm not sure if the files are re-sized or maintained within the userform at their original size.

[mortphil]

Hi Bernie,

I was trying to load one picture in the image1 field using loadpicture but I get an error saying "Loadpicture" sub or function not defined. I checked on Microsoft website, the syntax is LoadPicture(Path & name.jpg)

Please Login or Register  to view this content.

I am using excel 2007, would there be a dll or something else to activate ?

or do I need to write a function similar to yours "paste picture" you posted above for "loadpicture"?

[mortphil]

I noticed that OLE automation was not ticked in. I turned it on and it works!

[Bernie Deitrick]

That's what I like - self-solving problems!

I always use at least these 6 references to start:

References.JPG