Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calendar Control in UserForm
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calendar Control in UserForm
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 "D" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter date in userform using Calendar Control | Excel Discussion (Misc queries) | |||
exclude holidays on UserForm Calendar control | Excel Programming | |||
Programmactically add calendar control to userform | Excel Programming | |||
Calendar Control: Can't exit design mode because control can't be created | Excel Programming | |||
How to use Microsoft Calendar Control 9.0 on a Userform | Excel Programming |