Analytical Question: Download Analytical PDF
Within excel, what is the VBA coding to determine if the active cell has a comment assigned to it?
Answer:
Test: ActiveCell.Comment.Text
If ActiveCell.Comment.Text = "" Then
No Comment
If Not ActiveCell.Comment.Text = "" Then
Active Cell has a Comment
If ActiveCell.Comment.Text = "" Then
No Comment
If Not ActiveCell.Comment.Text = "" Then
Active Cell has a Comment