Thread: Comment Font Size
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sheldon Sheldon is offline
external usenet poster
  
Posts: 51
Default Comment Font Size
In code how do I change the comment font size?

I am creating the comment as follows

Sheet3.Range(strCol & strRow).AddComment
Sheet3.Range(strCol & strRow).Comment.Visible = False
Sheet3.Range(strCol & strRow).Comment.Text strComment
Sheet3.Range(strCol & strRow).Comment.Shape.TextFrame.AutoSize = True


Thanks
Reply With QuoteReply With Quote