Excel - Calendar Control in UserForm

Asked By D@discussions.microsoft.com on 21-Feb-08 11:01 AM
I have a User Form with a command button that is set to open another form
with a Calendar Control.

I would like to have the the date choosen in my frmCalendar to then be
entered into my main form (frmLoaner) in a field named txtOrderDate.   Also,
can I use this same frmCalendar to enter dates into other fields or do I need
to have seperate calendars?




MatthewPfluge replied on 21-Feb-08 01:19 PM
It is very possible to send a value between userforms.  Consider defining
Userform Properties.  Make sure that you copy the property from the
frmCalendar to the frmLoaner before Unloading it.

Also, using properties, you can build the frmCalendar in a way that it
return dates however often it is needed per form.  That's a very good idea.
Perhaps you could call it as a function:

frmLoaner.txtAnyTextbox.Value = frmCalendar.Date

I know this is just conceptual at this point, but you should be able to set
this up.

HTH,
Matthew Pfluger