ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Link Picture to a cell in Excel 2003 (https://www.excelbanter.com/excel-programming/389818-link-picture-cell-excel-2003-a.html)

phyllis_yeo

Link Picture to a cell in Excel 2003
 
I am trying to link a picture to a cell in Excel 2003.

My goal is to use vlookup command to pull out the particular picture related
to what I choose.

I am not able to make the cell and the picture link together.

Eg.

I have a dropdown menu with 10 items. When I choose any item in the dropdown
menu, the picture showing the item will appear.

I would like to do this in Excel without using VB.

Please help .... Thanks....

Gary''s Student

Link Picture to a cell in Excel 2003
 
http://www.mcgimpsey.com/excel/lookuppics.html
--
Gary''s Student - gsnu200723

phyllis_yeo

Link Picture to a cell in Excel 2003
 
Thanks for your solution.

Is there any other solution without enabling macro?

Thanks....

"Gary''s Student" wrote:

http://www.mcgimpsey.com/excel/lookuppics.html
--
Gary''s Student - gsnu200723


phyllis_yeo

Link Picture to a cell in Excel 2003
 
In addition, I have more than 50 pictures to add. Stated in your link, "a
database solution would likely be much easier and much more efficient". How
to go about doing this?

Thanks...


"Gary''s Student" wrote:

http://www.mcgimpsey.com/excel/lookuppics.html
--
Gary''s Student - gsnu200723


Gary''s Student

Link Picture to a cell in Excel 2003
 
The solution offered is a pretty standard way of meeting the objectives.
--
Gary''s Student - gsnu200723


All times are GMT +1. The time now is 01:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com