Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel comment formatting mleinok Excel Discussion (Misc queries) 3 June 27th 07 07:40 PM
Activating a comment box based on conditional formatting Andrew Rodriguez Excel Discussion (Misc queries) 2 October 3rd 06 02:53 PM
Formatting conditional on absence of comment Lon Sarnoff Excel Programming 3 February 7th 06 10:19 PM
formatting (underline/bold/strikethrough) in comment boxes adam l via OfficeKB.com Excel Discussion (Misc queries) 3 November 8th 05 05:55 PM
how to add text to a comment in VBA DB Excel Programming 3 November 4th 05 02:24 AM


All times are GMT +1. The time now is 08:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"