I have an add-in to excel that I have referenced in a formula. The add-in
retrieves a value from a database. When a value is not found, it displays
'No events found.' In an IF THEN ELSE statement, I'm checking for 'No events
found.', but when the cell meets that criteria it is not matching and just
goes to the 'Error' part of my Else statement (see below). My guess is that
my statement is retrieving the formula in the cell, and not the formula's
results. If I do a MSGBOX, I get the results and not the formula. Any
thoughts?

If (IsNumeric(Worksheets("Data").Range("A7").Value)) Then
MsgBox Worksheets("Data").Range("A7").Value 'show the value
ElseIf CStr(Worksheets("Data").Range("A7").Value) = "No events found."
Then
MsgBox "No events found."
Else
MsgBox "Error"
End If

I've tried it with and without the CStr function to see if it was a format
conversion issue to no avail.

Thanks