hi,
I am having a little problem with a text box on a form.
I don't seem to know the correct syntax.
the text box may or may not have something in it.
the code runs, does a lot of things but if the text box is
empty then the code is suppose to skip over part of the
code. if the text box has a number in it, then the code
should run the code associated with the text box.
in access the syntax would be:
if not (isnull(me.textbox) then
run this code and loop until lt.value = text box.value
end if
with this if statement, if the text box is empty then the
code would be skipped. if there is a number in the text
box, the code would run.
but in excel that don't seem to work. the code associated
with the text box runs whether the text box is empty or
not. this is causing a overflow problem due to endless run
away calculations leading to crash and burn.
Does anyone know what the correct syntax would be.

thanks in advance.
FSt1