ExcelBanter - annotation

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

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

- - annotation (https://www.excelbanter.com/excel-programming/384845-annotation.html)

jimmy[_5_]

annotation

How to write a annotation to a cell explain what the cell means?
Thanks

[email protected]

annotation

On Mar 8, 7:28 pm, "jimmy" wrote:
How to write a annotation to a cell explain what the cell means?
Thanks

Public Sub test()
Range("A1").AddComment Text:="This is annotation"
End Sub

adds a comment to the A1 cell of the active sheet
regards
Paul

All times are GMT +1. The time now is 05:38 PM.