In either way, you will need to implement the actions when you click on these controls.
Default size of the controls on UserForm:. Now the controls are in your Controls tab to add on UserForms. Scroll down and tick Microsoft Date and Time Picker Control 6.0 (SP6) or Microsoft MonthView Control 6.0 (SP6):. In the Toolbox for the UserForm selected, right click on empty space of the Controls tab, click Additional Controls. 
When you are out of Design Mode, clicking on the DTPicker control is like this, while the MonthView takes more space:.
Scroll down and select Microsoft Date and Time Picker Control 6.0 (SP6) or Microsoft MonthView Control 6.0 (SP6) then click OK.In Developer tab, Controls group, click Insert, then bottom right.
Date and Time Picker ( DTPicker), left/top of screenshots. If Controls("D" & (i)).BackColor &H80000016 Then Controls("D" & (i)).Once you have registered the mscomct2.ocx control ( YOU WILL NEED TO REGISTER THIS FILE ON ALL COMPUTERS THAT WILL USE THIS WORKBOOK!), you can either add one of below controls in the Worksheet or in a UserForm: If i = Weekday((CB_Mth.Value) & "/1/" & (CB_Yr.Value)) ThenĬontrols("D" & (i)).Caption = Format(DateAdd("d", (i - Weekday((CB_Mth.Value) _ 'sets the focus for the todays date button 'the routine that actually builds the calendar each timeĬalendarFrm.Caption = " " & CB_Mth.Value & " " & CB_Yr.Value Then, repeated the steps (1 to 4) lot of times. I followed these steps many times:ġ- Downloaded the control mscomct2.ocx from trustable online publisher.Ģ- Extracted it by ZibExtractor to the desktop then paste it manually in C:\windows\sysWOW64\.ģ- Registered the control through the Command Prompt by using this line Regsvr32 C:\windows\sysWOW64\mscomct2.ocx and received this message "DllRegisterServer in C:\windows\sysWOW64\mscomct2.ocx succeeded"Ĥ- However when I restart Excel and toolbox/Additional Controls, the Date & Time control picker is still missing!ĥ Unregistered the control through the Command Prompt by using this line Regsvr32/u C:\windows\sysWOW64\mscomct2.ocx and received this message "DllUnRegisterServer in C:\windows\sysWOW64\mscomct2.ocx succeeded". The Date and Time picker control is missing from my Excel/Microsoft office 16 - Windows 10/64bite.
0 kommentar(er)
