One way to learn how VBA refers to cell comments is to record a macro in
which you enter a comment in a cell, and then look at the VBA code that Excel
automatically returns.

That doesn't mean you'll have the precise syntax for what you're looking to
do, but it means you will have some idea of what code you're looking for.

Hope that helps/

"da@DRI" wrote:

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