Display Picture in worksheet

**modytrane** · 11-30-2007, 10:34 AM

I have searched thru several posts on this subject.
But I can't make it work for me. I amnot big on VBA coding, so I need help.
My problem is relatively simple.
I have a spreadsheet with annual project financials.
I would like to look at the year to date profit number and when it reaches a certain goal [% or $$], I would llike to display a picture [.jpg file] on the worksheet.
On another sheet I have booking numbers by salesperson.
Again, whichever salesperson reached his/her quota, I would like to display the respective picture.
The pictures can be inserted to the worksheet [no more than 10 pictures] or they can be retrived from the network.
Thanks for any help I can get.
Alan

**MickG** · 11-30-2007, 12:09 PM

Try this :-
1) Insert "Userform" in VBEditor Window
2) In VB Editor, Click "View", Click "ToolBox"
3) Click "Image", Drag Image onto "Userform."
4) Click Image Block, Click"F4", for "Image Properties" Window.
5) Double Click "Picture " property, choose picture from your selection, Click "Open"
6) Size Picture & Userform to Suit.
7) Close "Image properties".
8) In "Project- VBAproject" Window, Double Click "ThisWorkbook".
9) Copy & paste the code below into Window
10) Adjust the Range, Sum & Userform Name, in Code to suit.
11) When the Cell values are Equal or greater than your value the picture will show.

Please Login or Register  to view this content.

Regards Mick

**oldchippy** · 11-30-2007, 12:22 PM

Here's an alternative method

http://www.mcgimpsey.com/excel/lookuppics.html

**modytrane** · 11-30-2007, 03:41 PM

Thanks guys for responding.
I like mcgimpsey's solution.
But I have a question.
His excel sheet has four pictures named Picture 1, Picture 2 etc.
How do I look at that list?
Where are these picture assigned?
I tried assigning my pictures to the worksheet and change the names on his worksheet, but it doesn't work.
I would appreciate some explanation on how and where his worksheet looks for those picture filenames.

Thanks,
Alan