| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple picture inserts via dropdown lists
I have a workbook that has several dropdown menus. One of these menus is
linked so that a cell displays a picture depending upon the answer in the dropdown list. To achieve this I used this site provided in another answer on this site. http://www.mcgimpsey.com/excel/lookuppics.html Now to my problem. I need to reproduce this for other dropdowns on the same sheet. I tried copying the VB code and adjusting the cell ref but this gives me an error message and neither picture appears. I assume I need to add something to the VB code but not being well versed in this area I stuck. EG Dropdown list 1 Coresponding Picture 1 Dropdown list 2 Coresponding Picture 2 Dropdown list 3 Coresponding Picture 3 Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Hiding Validation Dropdown Lists | Excel Worksheet Functions | |||
| Insert Picture from dropdown selection | New Users to Excel | |||
| Dropdown Lists | Excel Discussion (Misc queries) | |||
| Dropdown Lists... | Excel Discussion (Misc queries) | |||
| Dropdown lists | Excel Discussion (Misc queries) | |||
Threaded Mode
