Resizing Comment Box

  • Thread starter Thread starter Eager2Learn
  • Start date Start date
E

Eager2Learn

I would like to set the size of the comment box I am adding. Here i
the part of the code with the comment:

.Offset(0, 2).AddComment "Reopened: " & Date

this is all in a With statement.

Help, please.
E2
 
E2L,

With .Offset(0, 2).Comment.Shape
.Width = 100
.Height = 200
End With

HTH,
Bernie
MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If ActiveCell has a comment then exit sub 22
Resize commentbox in VB 1
Copy to a mid column range Row 10 - Row 20 4
IF statement but in code 3
Re : Excel In Search of a Certain Comment 5
Format some, not all, text in a comment 2
copying cell comment from one sheet to another 2
Error Trapping Issues 8

Back
Top