Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
popup immage
I was wondering if it would be possible to make a popup window from a range
of small immages depending on which code is inserted in cell. When inserting a shape code in let say column B (number between 1 - 99) it corresponds with a certain shape and immage. The image show a small explainatory drawing of the shape in question, it shows the corresponding lengths for A, B, C. These lenghts are user difined and will be used in a formula to calculate the total "cut length" for the shape. Example shape code A B C D E 35 After inserting the shape code a little explanitory immage pops up during inserting of the value's A - E Or is this to much programming for a simple dude like me Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
popup immage
To have a picture show up based on VLOOKUP when you select an item from a DV
list or type in a name see JE MCGimpsey's site. http://www.mcgimpsey.com/excel/lookuppics.html As written John's code allows for only one picture to be displayed and the pictures must be stored on the same worksheet as the VLOOKUP formula. Or you need multiple pictures shown from VLOOKUPS............. Got to Debra Dalgeish's site for a sample workbook from Bernie Dietrick for adding pictures via selections. Allows for more than one picture to be displayed on a sheet but also requires the pictures be stored on same sheet. http://www.contextures.on.ca/excelfiles.html#DataVal DV0049 - ClipArt Selection Gord Dibben MS Excel MVP On Thu, 7 May 2009 07:02:01 -0700, willemeulen wrote: I was wondering if it would be possible to make a popup window from a range of small immages depending on which code is inserted in cell. When inserting a shape code in let say column B (number between 1 - 99) it corresponds with a certain shape and immage. The image show a small explainatory drawing of the shape in question, it shows the corresponding lengths for A, B, C. These lenghts are user difined and will be used in a formula to calculate the total "cut length" for the shape. Example shape code A B C D E 35 After inserting the shape code a little explanitory immage pops up during inserting of the value's A - E Or is this to much programming for a simple dude like me Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Popup box help? | Excel Programming | |||
How to popup msg box ? | Excel Programming | |||
popup box | Excel Programming | |||
"Why did we get here????" popup | Excel Discussion (Misc queries) | |||
Are you sure popup box | Excel Programming |