Can we search by the word in comment of a cell in excel 2016?
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Search by the word in comment
0
Discussion
Please don't forget to select the answer that worked best for you! Just click the Select Answer button at the bottom of the desired answer.
don (rep: 1989) Sep 30, '17 at 5:30 am
Answers
0
Yes, you can. However, to the best of my knowledge, you would require VBA to do so.
0
Use a macro like this:
Sub CommentsList()
Dim WS As Worksheet
Dim Rng As Range
Dim cell As Variant
Dim i As Single
Set Rng = ActiveSheet.Cells.SpecialCells(xlCellTypeComments)
Set WS = Sheets.Add
WS.Range("A1") = "Cell"
WS.Range("B1") = "Comment"
i = 2
For Each cell In Rng
WS.Range("A" & i) = cell.Address
WS.Range("B" & i) = cell.Comment.Text
i = i + 1
Next cell
End Sub
It will list the comments from the current worksheet.
Adjust the cell references in the macro to the columns where you want the results to appear. By default, they appear in column A and B and you can change those values in the macro to whatever column you want.
Once you have the list of comments in Excel, you can use Ctrl + F to find the text.