Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
insert an ICON in a cell
How can I insert an icon in a cell programatically?
-- Thanks, Uwe |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
insert an ICON in a cell
Can you supply more information?
What icon? from where? A network file? an image in the workbook? What prompts the insertion? User selection? Something else? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Uwe" wrote in message ... How can I insert an icon in a cell programatically? -- Thanks, Uwe |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
insert an ICON in a cell
Hi Uwe
You can try this for cell D5 Sub test() Dim myPict As Picture With ActiveSheet.Range("D5") Set myPict = .Parent.Pictures.Insert("C:\YourPic.bmp") myPict.Top = .Top myPict.Width = .Width myPict.Height = .Height myPict.Left = .Left myPict.Placement = xlMoveAndSize End With End Sub -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Uwe" wrote in message ... How can I insert an icon in a cell programatically? -- Thanks, Uwe |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
insert an ICON in a cell
I have some text from a database attached to a cell a a comment. This is
working quite will with the red triangle at the top of the cell. The client want to show a paperclip image in the cell to more graphically show a comment is associated with the cell. -- Thanks, Uwe "Ron de Bruin" wrote: Hi Uwe You can try this for cell D5 Sub test() Dim myPict As Picture With ActiveSheet.Range("D5") Set myPict = .Parent.Pictures.Insert("C:\YourPic.bmp") myPict.Top = .Top myPict.Width = .Width myPict.Height = .Height myPict.Left = .Left myPict.Placement = xlMoveAndSize End With End Sub -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Uwe" wrote in message ... How can I insert an icon in a cell programatically? -- Thanks, Uwe |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
insert an ICON in a cell
Hi Uwe
See if Debra have something for you http://www.contextures.com/tiptech.html But I think there is no way to change the red triangle and you must add a icon on top of the cell if you always want to see it -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Uwe" wrote in message ... I have some text from a database attached to a cell a a comment. This is working quite will with the red triangle at the top of the cell. The client want to show a paperclip image in the cell to more graphically show a comment is associated with the cell. -- Thanks, Uwe "Ron de Bruin" wrote: Hi Uwe You can try this for cell D5 Sub test() Dim myPict As Picture With ActiveSheet.Range("D5") Set myPict = .Parent.Pictures.Insert("C:\YourPic.bmp") myPict.Top = .Top myPict.Width = .Width myPict.Height = .Height myPict.Left = .Left myPict.Placement = xlMoveAndSize End With End Sub -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Uwe" wrote in message ... How can I insert an icon in a cell programatically? -- Thanks, Uwe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert option icon | Excel Discussion (Misc queries) | |||
Icon Sets - Display icon in one cell depending upon value in anoth | Excel Worksheet Functions | |||
How can I insert a date with an icon (calendar) insert | Excel Discussion (Misc queries) | |||
2007 insert button/icon | Excel Worksheet Functions | |||
'Insert Rows Icon' | Excel Discussion (Misc queries) |