Good morning everyone,
I am having difficulty combining calendars. I know that best way would be to add a Date Picker but the frame and format seems to be small, therefore I am using the Calendar Control from Excel.
I have a main calendar that Controls the sheets. Module included:
Module:
I have multiple Userforms that will need to access this Calendar but the only work around I have been able to find online and others, is to add 2 other calendar to control all my information in my Userforms.
I have a Userform that requires 2 date entries. So, one textbox being controlled by one calendar, and the other by another.
Problem is I would like to have everything controlled by one Calendar and not to have to control everything separately.
So this said:
I have
UserForm (frmCalendar) – Normal Sheet Control
UserForm (frmCalendar2) – UserForm Control for first date entry
UserForm (frmCalendar3) – Userform Control for second date entry.
Problem is, sometime when a Userform is generated; it will add a date out of nowhere in a textbox that is supposed to be blank.
Here are my Codes from the 2 Calendars controlling the userforms:
UserForm (frmCalendar2):
UserForm (frmCalendar3):
Would there be a more easier way to control my dates with this type of calendars or I should I leave it as is...
The reason why I am using mutliple calendar is to control the information being inserted in the individual textbox in the UserForms... If there is 2 textbox in one userform that requires dates then it will be individually controlled.
:D
Excel Noub
Bookmarks