Comment Object being recognized as 'Nothing'

[BreitLink]

Hi y'all,

I'm trying to create a macro capable of performing a function when a given cell contains a comment. I have read in many places to use "If Not . Comment Is Nothing Then", but every time I test it out with a cell I know has a comment, it recognizes the condition object as 'Nothing'

Sheet.png.jpg

Code.jpg

As seen, cell C2 has a comment, but when I hover over the TestObj it displays as nothing. I have also tried with CommentThreaded and other related objects but I cannot get it to work.

[jolivanes]

Try (Change references as required)

Please Login or Register  to view this content.

[BreitLink]

I get a Run-Time error when trying it. I used an object variable to be able to see what the object gets recognized as and sure enough, it still recognizes it as 'Nothing'.

Attachment 745272

[TMS]

Answered many years ago on this forum. See: https://www.excelforum.com/excel-gen...in-a-cell.html

[BreitLink]

I have looked at both the responses on that thread before, still have issues.

Please Login or Register  to view this content.

This still prints "Nothing" on C2 even though cell B2 (the cell called by Cells(2,2)) has a comment.

[BreitLink]

For any future users that have this same problem, I eventually found a way to check the existence of a comment in a given cell using .CommentThreaded.

Please Login or Register  to view this content.

For some reason, .Comment didn't work for this type of condition, yet .Comment.Text was able to print the text inside the comment.