Excel: Get cell comments

Categories: Development Notes; Tagged with: ; @ August 23rd, 2012 19:05

1. Alt + F11, in the opening window, click: Insert>Module, paste the folling code:

Function getComment(incell) As String
On Error Resume Next
getComment = incell.Comment.Text
End Function

2. Alt + Q to quit the window

3. use the funciton in cell, like:
=getComment(A1) , will fill the cell with A1’s comments



// Proudly powered by Apache, PHP, MySQL, WordPress, Bootstrap, etc,.