Calendar UserForm question

[DougRobertson]

Hello,

I have created a pop-up calendar userform in Excel VBA (2010). It works well for clicking on a day in the calendar and having the macro enter that date in a specific cell. However, I don't want to do that.

I'd prefer having the date information kept in the memory, so I can use it in different ways for file naming etc., but when the macro switches back to the original macro, iDate (for instance) goes back to Empty.

Is there a way to have the date info stay in memory?

Thanks in advance,

~ Doug

 

[tlowry]

Put the declaration for iDate in a module making it public.

iDate will keep the last picked date until the app closes.

Public iDate As Date
Sub test()
    MsgBox iDate
End Sub

Code in the form:

Private Sub DTPicker1_Change()
    iDate = Me.DTPicker1.Value
End Sub

 

[DougRobertson]

Could you be a little more specific - the macro doesn't seem to like the code.