Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting certain text within a comment
I did some research on this forum and even though this question has bee asked, it was never really answered: I would like to bold, underline, or strikethrough only certain word within a comment. For instance: *Due Date:* 08/15/06 I've only found things that would bold the entire comment. Thanks in advance -- pikapika1 ----------------------------------------------------------------------- pikapika13's Profile: http://www.excelforum.com/member.php...fo&userid=1089 View this thread: http://www.excelforum.com/showthread.php?threadid=56107 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting certain text within a comment
from an old posting of mine:
Sub AddComment() Dim cmt As Comment Set cmt = ActiveCell.AddComment With cmt.Shape.TextFrame .Characters.Text = "This is some Text for the Comment" .Characters.Font.Name = "Times Roman" .Characters.Font.Size = 14 .Characters(14, 4).Font.Bold = True .Characters(1, 4).Font.ColorIndex = 3 End With End Sub -- Regards, Tom Ogilvy "pikapika13" wrote: I did some research on this forum and even though this question has been asked, it was never really answered: I would like to bold, underline, or strikethrough only certain words within a comment. For instance: *Due Date:* 08/15/06 I've only found things that would bold the entire comment. Thanks in advance. -- pikapika13 ------------------------------------------------------------------------ pikapika13's Profile: http://www.excelforum.com/member.php...o&userid=10892 View this thread: http://www.excelforum.com/showthread...hreadid=561073 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel comment formatting | Excel Discussion (Misc queries) | |||
Activating a comment box based on conditional formatting | Excel Discussion (Misc queries) | |||
Formatting conditional on absence of comment | Excel Programming | |||
formatting (underline/bold/strikethrough) in comment boxes | Excel Discussion (Misc queries) | |||
how to add text to a comment in VBA | Excel Programming |