Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want a macro that has Note: instead of username, in bold
and then pauses for the rest of the text. From www.contextures.com I found. Sub CommentAddOrEdit() 'adds new plain text comment or positions 'cursor at end of existing comment text Dim cmt As Comment Set cmt = ActiveCell.Comment If cmt Is Nothing Then ActiveCell.AddComment text:="Note: " End If SendKeys "%ie~" End Sub But how do I make the Note: bold and reset to normal for text input. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
comment format | Excel Discussion (Misc queries) | |||
How can i set preliminary format for comment box? | Setting up and Configuration of Excel | |||
How to change comment format? | Excel Discussion (Misc queries) | |||
Decide comment format 'globally'? Restore format with ws_change? | Excel Discussion (Misc queries) | |||
How do I set up the default format for a comment? | Excel Discussion (Misc queries) |