How do I re-size a comment box using VBA?

  • Thread starter Pete at Sappi Fine Paper
  • Start date
P

Pete at Sappi Fine Paper

Recording a macro does not help - it gives:

Selection.ShapeRange.ScaleWidth 0.41, msoFalse, msoScaleFromTopLeft
Selection.ShapeRange.ScaleHeight 0.22, msoFalse, msoScaleFromTopLeft

But replacing "Selection" with "Range("B" & 15).comment" does not work.

Any ideas, please? Thanks!

Pete
 
A

Andy Pope

Hi,

Try,

With Range("B" & 15).Comment.Shape
.ScaleWidth 0.41, msoFalse, msoScaleFromTopLeft
.ScaleHeight 0.22, msoFalse, msoScaleFromTopLeft
End With

Cheers
Andy
 
P

Pete at Sappi Fine Paper

That worked!! Thanks Andy!

Andy Pope said:
Hi,

Try,

With Range("B" & 15).Comment.Shape
.ScaleWidth 0.41, msoFalse, msoScaleFromTopLeft
.ScaleHeight 0.22, msoFalse, msoScaleFromTopLeft
End With

Cheers
Andy
Click to expand...
 

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

VBA to edit a comment 3
How to change comment Box width and high 2
Control the size of a Comment Box in Excel 2007 from Access 2007 1
Rescaling a Comment text-box 3
Insert Pic Which User Chooses into Comment 1
How do I insert Text Box in ActiveCell 2
Setting size of comment under macro control? 2
Resize picture in VBA 0

Top