CDATE issues

[Marcus]

Please help a novice

I am using the cdate function to populate a number of
textboxes in a userform with date information. However
when the fields are empty cdate returns 00:00:00 into the
textbox.

Is their anyway to force the textbox to be blank rather
than 00:00:00 when no date exists.

I am self taught so please make any explanation dummy
prove

Many thanks

Marucs

 

[Guest]

Hi
maybe use an if statement:
e.g.
with activesheet.range("A1")
if .value<>"" and isnumeric(.value) then
textbox1.value=cdate(.value)
else
textbox1.value=""
end if
end with