Inserting Comments in Excel

  • Thread starter Thread starter Richard Grene
  • Start date Start date
R

Richard Grene

Using the following code I am able to insert a comment into my excel
spreadsheet from vb.net.

How can I then resize the comment?

Thanks,

Richard

oSheet.Range("B1").AddComment()

oSheet.Range("B1").Comment.Visible = True

oSheet.Range("B1").Comment.Text(Text:="Any Comment")
 
Richard Grene said:
Using the following code I am able to insert a comment into my excel
spreadsheet from vb.net.
Click to expand...

You may want to ask this question in this group:

<
 
¤ Using the following code I am able to insert a comment into my excel
¤ spreadsheet from vb.net.
¤
¤ How can I then resize the comment?
¤
¤ Thanks,
¤
¤ Richard
¤
¤ oSheet.Range("B1").AddComment()
¤
¤ oSheet.Range("B1").Comment.Visible = True
¤
¤ oSheet.Range("B1").Comment.Text(Text:="Any Comment")
¤
¤


Range(XX).Comment.Shape.TextFrame.AutoSize = True


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top