Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I use icons and pictures with Excel 4 dialog.box functi
Thanks Hector.
I was close but the naming of the embedded picture was the trick I missed. However, I can only get it to work for type 23, picture. There's still no joy with type 17, icon. I'm not quite certain what the different consequences of using 17 or 23 are - 23 does what I wanted to do perfectly well - but for curiosity I'd be interested in beating the icons. Is the type of source file relevant? Or the method of embedding? Chris "Héctor Miguel" wrote: hi, Chris ! The old Excel 4 dialog.box function has various permissible data types accepted in the first field. 17 is icon and 23 is picture. How do I tell Excel what the icon or picture is that I want to include? Presumablty there is something to enter in the sixth field, but I cannot work out a valid value or formula... - embed the picture (with)in your xl4 macro-sheet - (while selected) give/assign/... a name to that (each ?) picture - use "the name" as the 6th column value (same item row) regards, hector. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I use icons and pictures with Excel 4 dialog.box functi
hi, Chris
I was close but the naming of the embedded picture was the trick I missed. However, I can only get it to work for type 23, picture. There's still no joy with type 17, icon. I'm not quite certain what the different consequences of using 17 or 23 are - 23 does what I wanted to do perfectly well - but for curiosity I'd be interested in beating the icons. Is the type of source file relevant? Or the method of embedding? icon type (17) accepts only numbers 1 to 3 as follows: (and the "icons" are their simil to vba: vbQuestion, vbInformation, vbExclamation) 1: ? (question mark) 2: i (information) 3: ! (alert triangle) any "icon" referring to an image, shall be type 23 hth, hector. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to create a dropdown list with pictures/icons ? | Excel Discussion (Misc queries) | |||
Challenging question: add TIME TREND in Excel with built-in functi | Excel Discussion (Misc queries) | |||
SORT (Excel) doesn't work in a column created from a LOOKUP functi | Excel Programming | |||
Macro to delete various pictures and hyper-link picture icons | Excel Worksheet Functions | |||
How do I display embedded pictures in Excel as icons? | Excel Discussion (Misc queries) |