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?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?If Not lowest_score.Comment.Text Is Nothing Then
i believe "is nothing" is associated with an object, but your .text is just a string. it would be better to use isnull()
[vba]
Dim cmtValue As String
On Error Resume Next
cmtValue = lowest_score.Comment.Text
On Error GoTo 0
If cmtValue <> "" Then
'...
End If
[/vba]
Last edited by Bob Phillips; 01-26-2008 at 03:13 AM.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
[cba] ....must be a British thing...Originally Posted by xld
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
ROFLOriginally Posted by Aussiebear
"Intellectual passion occurs at the intersection of fact and implication."
SGB