Rolly_Sefu
06-03-2019, 03:38 AM
Hello,
The company that i work in made some changes in windows, and i can't see the Calendar userform from Excel ( missing from pc: Microsoft MonthView Control 6.0 )
So i found a calendar that someone created, but i am having trouble adjusting it me my needs.
I managed to disable the selection for the weekend.
And to always have the selection on today.
Managed to load it from a userfrom, and send the date into another textbox.
The problem i have:
Today is 3'rd June, and i select a date from january.
Next time i load the userform i want the calendar to show June month (month from today), NOT JANUARY
But the wierd thing is if i don't select a date the second time ( i close the calendar )
The 3'rd time i open the userform it is back to the correct month.
Can anyone help me identify the code lines that i need to change ? (file is in the attachment)
Thank you.
The company that i work in made some changes in windows, and i can't see the Calendar userform from Excel ( missing from pc: Microsoft MonthView Control 6.0 )
So i found a calendar that someone created, but i am having trouble adjusting it me my needs.
I managed to disable the selection for the weekend.
And to always have the selection on today.
Managed to load it from a userfrom, and send the date into another textbox.
The problem i have:
Today is 3'rd June, and i select a date from january.
Next time i load the userform i want the calendar to show June month (month from today), NOT JANUARY
But the wierd thing is if i don't select a date the second time ( i close the calendar )
The 3'rd time i open the userform it is back to the correct month.
Can anyone help me identify the code lines that i need to change ? (file is in the attachment)
Thank you.