Need to show a pic by clicking in a cell, or similar

[install4you]

Greetings to All!

This is my first post to the forum. Thanks in advance to anyone who shares a potential solution or part of 1.

I'm using Excel from Office 2010 Pro. It's been I while since I used Excel +/- 12 hours a day. Sorry to say I never learned Visual Basic. I was pretty good with combining formulas, formatting, etc., to produce a complex result. I hope I remember at least 1/2 of what I used to know.

I want to imbed some pictures in a workbook and have them appear on the current sheet when I select a cell. The pic would disappear when I click in any other cell. I wanted to place pics on a sheet at the end of the workbook. My initial efforts have failed for 2 primary reasons: 1) linking anything to a cell requires a reference to an external source in all the formulas I've tried; 2) I've forgotten how or never knew how to imbed a pic in or associate a pic with a cell, thus providing a location reference.

This is for a kinda over-the-top personal project; however, I just love learning new stuff & justify using the time by saying maybe I'll use the solution for some work project. This workbook would function like a catalogue where you click on a product by name and the pic pops up. I have some purchases to make and there are hundreds of brands, thousands of items, & an endless variety of set combinations.

If this can't be done without Visual Basic, I have dabbled with VB a little. I could try to use suggested code.

Any help will be appreciated. If compensation is required, I'd be glad to barter for information to help you with installing drapery, blinds, etc., hanging pics/mirrors, or helping you by phone to assemble something.

Eddie
install4you

[mehmetcik]

Try this as a start

I have pasted three Photo in Sheet2

They have Names but I am referencing them using their index numbers.

That is the order that they were pasted into the workbook.

Selecting Rows 1 to 3 will paste the relevent picture into Sheet 1.

There are two Macros involved.

The First Macro Simply Runs the Main Macro whenever you click on a cell on Sheet 1 :


Right Click On Your Sheet Name At the Bottom Of Excel and Select View Code

Please Login or Register  to view this content.

The Main Macro is in a normal Macro Module.

Select the developer tab
Select view and then project explorer
Select your project
Select insert and then module

Please Login or Register  to view this content.

[Misanthrope]

Not sure this is exactly what your looking for, but it is possible to use the Comment function
to display a picture when you select a cell.

Try this
Open Excel Spreadsheet

Step 1: Select a cell
Step 2: Right click, select "Insert Comment"
Step 3: Right click "the border" of the comment box, select "Format Comment"
Step 4: Left click on "Colors and Lines" tab
Step 5: Left click on "Fill Color" button
Step 6: Left click on "Fill Effects" button
Step 7: Left click on "Picture" tab
Step 8: Left click on "Select Picture" button
Step 9: Browse to the picture location on your hard drive
Step 10: Double click on Picture Name
Step 11: click "OK"
Step 12: click "OK"

Next:
Go to Excel Options
Select "Advanced"
Scroll down to the "Display" options
Select "Indicators only and comments on hover"
Click OK

Now when you hover over the cell the picture will display and
when you move off the cell the picture disappears.