var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Excel, Comment
suppose the cmt is string variable
cmt = "Invoice 1:" & Chr(10)
cmt = cmt & "Num: 1" & Chr(10)
cmt = cmt & "Company: Microsoft"
cmt = cmt & Chr(10)
cmt = cmt & "Invoice 2:" & Chr(10)
cmt = cmt & "Num: 2" & Chr(10)
cmt = cmt & "Company: IBM"
.Worksheets(1).Cells(1, 5).AddComment cmt
.Worksheets(1).Cells(1, 5).Comment.Shape.TextFrame.Characters.Font.Bold = False
I used the above code to do the comment, but I want to set "Invoice 1" and "Invoice 2" to be Bold = True only.
How can I change?
Does anybody know that? Thanks.
The programming interface for Excel does not appear to give you format control over comments. Even the InterOp infor for .NET only references a Text String for this Object.
Did you post this the Excel forum?
I also have searched on this topic. While it can be done directly in Excel in the comment, I haven't found a VBA solution to changing part of that format.