Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Use the characters method.
Sub modify() Dim cmt As Comment Set cmt = ActiveCell.Comment With cmt.Shape With .TextFrame.Characters(7, 8) .Font.Size = 16 .Font.ColorIndex = 3 .Font.Name = "Times New Roman" End With End With End Sub as an example -- Regards, Tom Ogilvy "hglamy" wrote in message ... Hello there, how can I format different aspects of a comment such as font color etc. by way of vba ? Help is greatly appreciated. Thank you in advance. Kind regards, H.G. Lamy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel 2000 how to format the comments font all comments | Excel Discussion (Misc queries) | |||
Comments Format Help | Excel Worksheet Functions | |||
Pivot table: how to programmatically format headers? | Excel Discussion (Misc queries) | |||
Programmatically Format Comments | Excel Programming | |||
Date format when opening a .CSV file programmatically | Excel Programming |