Object required error

[Asterix]

If Not lowest_score.Comment.Text Is Nothing Then

If lowest_score.Comment.Text evaluates to "1.13" in the watch window, then why do I get an "Object required" error when I run the line above?

[akn112]

i believe "is nothing" is associated with an object, but your .text is just a string. it would be better to use isnull()

[Bob Phillips]

Dim cmtValue As String
On Error Resume Next
cmtValue = lowest_score.Comment.Text
On Error GoTo 0
If cmtValue <> "" Then

'...
End If

[Aussiebear]

[cba]

Dim cmtValue As String
On Error Resume Next
cmtValue = lowest_score.Comment.Text
On Error GoTo 0
If cmtValue <> "" Then

'...
End If
[/vba]

[cba] ....must be a British thing...

[Carl A]

[cba] ....must be a British thing...
ROFL:rofl: