ExcelBanter - Change size of comments?

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

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

- - Change size of comments? (https://www.excelbanter.com/excel-programming/331904-re-change-size-comments.html)

cmpf

Change size of comments?

I'm presuming the question is 'how can one change the size of comments from
vba?'

I seem to recall having some difficulty getting functioning syntax to do
this. I finally got it working with this sort of thing:

..Cells(CommentcellRow, CommentCellColumn).Comment.Shape.Width = 220

"unknown" wrote:

All times are GMT +1. The time now is 04:55 PM.