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

Private sub Calendar1_click()
ndate = userform1.calendar1.value
End Sub

"popup calendar" is not self defining, so that is a guess.

--
Regards,
Tom Ogilvy

"Erik" wrote in message
...
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

Right. But how do I reference ndate in a sub in module 1?

"Tom Ogilvy" wrote:

Private sub Calendar1_click()
ndate = userform1.calendar1.value
End Sub

at the top of the module (module10) outside any procedures (subs or
functions)

Public nDate as Date

Sub Testit()
msgbox nDate
End Sub

--
Regards,
Tom Ogilvy

"Erik" wrote in message
...
Right. But how do I reference ndate in a sub in module 1?

"Tom Ogilvy" wrote:

Private sub Calendar1_click()
ndate = userform1.calendar1.value
End Sub

Thank you. I got that part of my code working.

"Tom Ogilvy" wrote:

at the top of the module (module10) outside any procedures (subs or
functions)

Public nDate as Date

Sub Testit()
msgbox nDate
End Sub

--
Regards,
Tom Ogilvy

"Erik" wrote in message
...
Right. But how do I reference ndate in a sub in module 1?

"Tom Ogilvy" wrote:

Private sub Calendar1_click()
ndate = userform1.calendar1.value
End Sub

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