Setup a couple of public variables, and load these variables from within the
form before closing the form down.

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Val" wrote in message
...
I have a macro which filters the data based on two dates. Currently, the
dates must be entered in two cells before running the macro. Macro is then
referring to these two cell values. I'm trying to improve and have the
user
promted to enter start and end dates through the frmCalendar, which I
already
created. Is it possible to program this and save these two variables in
VBA
for future use?

I started with

' Start date variable
Public sDate as Date
' End date variable
Public nDate as Date
MsgBox "Enter Start Date"
frm.Calendar.Show

Getting an error so far. Any idea how to make it work? Thank you.

Val