format the cell Comment

  • Thread starter Thread starter sid
  • Start date Start date
S

sid

Can I change the format of the comment in excel ?

I need it to be wider and shorter.

Thanks
 
try these or some variation

activecell.Comment.Shape.Width = 212
activecell.Comment.Shape.height = 25
 
try these or some variation

activecell.Comment.Shape.Width = 212
activecell.Comment.Shape.height = 25

--

Gary








- Show quoted text -
Click to expand...

That worked, Thanks

Is there such an option as "Auto Width ..." ?
 
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

Excel Import Comments 3
Code to add comments to selected cells within a selected range 30
If ActiveCell has a comment then exit sub 22
Copy Cell to Comment 2
Copying a Picture From Cell Comment 0
Excel Linking (I think) 17
Control of cell comments lsot in Office10 1
Word to Excel: Export comments with text and line number 0

Back
Top