Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Zobah Mizrachi   on Nov 30 In MS Office Category.

How can i let VBA know the ActiveCell has Comment Text or not


  
Question Answered By: Dirck Jansen   on Nov 30

Then you post, please always indicate WHAT the error is. Also post your
actual code, not a hand-typed version of it.

However ...

Private Sub CommandButton1_Click()
If ActiveCell.Comment Is Nothing Then
MsgBox ("empty")
Else
MsgBox (ActiveCell.Comment.Text)
End If
End Sub

Share: 

 

This Question has 1 more answer(s). View Complete Question Thread

 


Tagged: