ExcelBanter - how to resize the comment in a cell

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

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

- - how to resize the comment in a cell (https://www.excelbanter.com/excel-programming/372287-how-resize-comment-cell.html)

how to resize the comment in a cell

I have inserted comments in a cell & I need to use VBA to resize the comment
box in a designated cell.

Appreciate any ideas.

Thanks,

YH

Tom Ogilvy

how to resize the comment in a cell

Range("C5").Comment.shape.height = 80
Range("C5").Comment.shape.Width = 120

--
Regards,
Tom Ogilvy

"YH" wrote:

I have inserted comments in a cell & I need to use VBA to resize the comment
box in a designated cell.

Appreciate any ideas.

Thanks,

YH

All times are GMT +1. The time now is 12:03 AM.