Thread: Can I do conditional formula based on data in cell comment?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
SIR Knight SIR Knight is offline
external usenet poster
  
Posts: 27
Default Can I do conditional formula based on data in cell comment?
Hi

You would need to refer to the cell in VBA

EG....

if Range("A1").comment.text = "Hello" Then
MsgBox "Say Hello"
End If

I don't think you can refer to a comment in a formula without VB

Steve

Reply With QuoteReply With Quote