Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On Mon, 9 Jun 2008 02:18:20 -0700 (PDT), stefan onken
wrote: Sub BoldFirstLineOfComment() With Range("A1").Comment l = InStr(.Text, Chr(10)) .Shape.TextFrame.Characters(1, l).Font.Bold = True End With End Sub Many thanks indeed. Works spot on ! Cheers - Kirk PS This thing I'm doing just about makes the tea & toast Now :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Question regarding comments | Excel Worksheet Functions | |||
Comments question | Excel Worksheet Functions | |||
Question - Excel Comments to Word Footnotes | Excel Discussion (Misc queries) | |||
A Question Regarding Comments | Excel Discussion (Misc queries) | |||
Cell Comments question | Excel Programming |