The best way to do this is to create a global variable called nDate (or
whatever) in module1. You could also temporarily store the value in a
worksheet form on the calendar click event, & then retrieve it in your sub
procedure.

"Erik" wrote:

I have created a popup calendar in a user form, but I can't figure out how to
get the date clicked on into a variable in a sub. Basically, I want my sub
to call the calendar and assign the selected value to variable nDate to used
later. Any suggestions?
Erik