Also, if you terminate a procedure with "end", it resets variables.
If you want to terminate the procedure other than by falling thru the "end
sub", use "exit sub".

"Patrick Simonds" wrote:

I have a userform which contains a Calendar Control. When I select a date on
the Calendar Control I want Calendar.Value to be public so that it can be
used in another module.