You can see the difference even on a worksheet:

Put 123 in A1
Put '123 in B1
put =a1=b1
in C1.

The apostrophe makes the value text. And text numbers are different from number
numbers.



"SA3214

Yes - I think you are put your finger on it ...
I've not been able to undo all the changes I've made in order to replicate
the situation.
I am somewhat confused by the need to convert entries in textboxes to
numeric especially when comparing them to entries in a spreadsheet
(I'm still very new to vba and inexperienced ... I also tend to write the
code on the fly without a program flow diagram or a functional spec)
I do have some reference books and use the vba help whenever I can but I
think I need a more structured course in programming

Thank you for your help and guidance

"Dave Peterson" wrote in message
...
What's in Textbox4? Is it numeric?

My bet is that it's not.

In my simple testing, if textbox4 was empty, it would cause this error,
too.

"SA3214

--

Dave Peterson