In my form I'm trying to force users to enter values in specific cells
by preventing users from continueing to complete the form without date
enter in the specific cells. I haven't been able to locate any reason
for the variable values to be dropped so it may be something in my
coding. In trying to check for values in specific cells I'm setting
Public variables (as Range) to the range of the cell I'm wanting to
check. I'm then checking the value of that variable to see if it is
blank as exampled below. Is there a better (more reliable/easier) way
of doing this?

======
Public objDate as Range
set objDate = Range ("h15")
..
..
Call Check_Date
..
..

Sub Check_Date
If objDate.Value = "" Then
..
..
..
End Sub
======

--
BrianG