Thanks, I've been reviewing the "Programming" section of Excel. It looks like
I'll have to teach myself VBA!


"SIR Knight" wrote:

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