INSERT icon from c:\mydir... in cell

User avatar
sal21
PlatinumLounger
Posts: 4334
Joined: 26 Apr 2010, 17:36

INSERT icon from c:\mydir... in cell

Post by sal21 »

I have a icon (gif) in c:\mydir\icons\ico1.gif

i need to insert this icon to the right of this value similar:

ws.Range("AG" & RIGA1).Value = Format(SDO, "#,##0.00")& " "& c:\mydir\icons\ico1.gif

how to via vba code?
Tks.

User avatar
HansV
Administrator
Posts: 78238
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: INSERT icon from c:\mydir... in cell

Post by HansV »

That is not possible. You can display the icon on top of the cell, but not in the value of the cell.
Best wishes,
Hans