Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a spreadsheet that is a customer order form which uses several VLOOKUP
functions to get item number, description and price. I want to add the ability for my customer to view an image (or picture, or object) that is tied to a specific item number. I have tried hyperlinks and icons but I cannot figure out how to link the image to a specific item so that when a customer is on line 1 of the order and he selects an item but is unsure what it looks like, he can view the image of that item. Any thoughts or help would be greatly appreciated. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
John McGimpsey shows how it can be done he
http://www.mcgimpsey.com/excel/lookuppics.html Hope this helps. Pete On Mar 9, 10:26*pm, darkside7out wrote: I have a spreadsheet that is a customer order form which uses several VLOOKUP functions to get item number, description and price. *I want to add the ability for my customer to view an image (or picture, or object) that is tied to a specific item number. *I have tried hyperlinks and icons but I cannot figure out how to link the image to a specific item so that when a customer is on line 1 of the order and he selects an item but is unsure what it looks like, he can view the image of that item. Any thoughts or help would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Objects & images move when viewing in print preview or printing. | Excel Discussion (Misc queries) | |||
Images/objects moving when printing or print preview. | Excel Discussion (Misc queries) | |||
Pictures adding & removal | Excel Worksheet Functions | |||
How to print individual pictures or objects only, in excel | Excel Discussion (Misc queries) | |||
adding images to excel table automatically | Excel Discussion (Misc queries) |