ExcelBanter - format the cell Comment

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - format the cell Comment (https://www.excelbanter.com/excel-programming/411297-format-cell-comment.html)

sid[_2_]

format the cell Comment

Can I change the format of the comment in excel ?

I need it to be wider and shorter.

Thanks

Gary Keramidas

format the cell Comment

try these or some variation

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

--

Gary

"sid" wrote in message
...
Can I change the format of the comment in excel ?

I need it to be wider and shorter.

Thanks

sid[_2_]

format the cell Comment

On May 21, 9:59*am, "Gary Keramidas" <GKeramidasATmsn.com wrote:
try these or some variation

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

--

Gary

"sid" wrote in message

...

Can I change the format of the comment in excel ?

I need it to be wider and shorter.

Thanks- Hide quoted text -

- Show quoted text -

That worked, Thanks

Is there such an option as "Auto Width ..." ?

All times are GMT +1. The time now is 01:13 PM.