View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Polymetals Chris Polymetals Chris is offline
external usenet poster
 
Posts: 2
Default 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.