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.Download Microsoft Date And Time Picker Control 6.0 Sp6. When you are out of Design Mode, clicking on the DTPicker control is like this, while the MonthView takes more space. Scroll down and tick Microsoft Date and Time Picker Control 6.0 (SP6) or Microsoft MonthView Control 6.0 (SP6): Scroll down and select Microsoft Date and Time Picker Control 6.0 (SP6) or Microsoft MonthView Control 6.0 (SP6) then click OK.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 rightbutton for More Controls.Date and Time Picker ( DTPicker), left/top of screenshots.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:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |