Thread: How do I re-size a comment box using VBA?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pete at Sappi Fine Paper
 
Posts: n/a
Default How do I re-size a comment box using VBA?
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
Reply With QuoteReply With Quote