Within excel, what is the VBA coding to determine if the active cell has a comment assigned to it?
Submitted by: AdministratorTest: ActiveCell.Comment.Text
If ActiveCell.Comment.Text = "" Then
No Comment
If Not ActiveCell.Comment.Text = "" Then
Active Cell has a Comment
Submitted by: Administrator
If ActiveCell.Comment.Text = "" Then
No Comment
If Not ActiveCell.Comment.Text = "" Then
Active Cell has a Comment
Submitted by: Administrator
Read Online Analytical Job Interview Questions And Answers
Top Analytical Questions
☺ | Statement A: All great men are ridiculous; |
☺ | All chickens lay eggs (True/False)? |
☺ | Please give the missing letter of the following 5 6 _ 87 412 2185? |
☺ | A invests $12000, B invests $8000, C invests $6000 and they got a profit of $1200. How much share A got more than B and C? |
Top Basic Job Categories
☺ | Targeted Selection Interview Questions. |
☺ | Business intelligence Interview Questions. |
☺ | Puzzles Interview Questions. |
☺ | Behavioral Interview Questions. |
☺ | Freshers Graduate Interview Questions. |