I have the same question (961) Report abuse Report abuse. You can vote as helpful, but you cannot reply or subscribe to this thread. Hide End Sub ' for Datefield ranges, need to initialize the datepicker before fields are clicked Private Sub UserForm_Initialize() Set theDatepicker2 = CreateObject( "DatePicker.DatePicker" ) 4, 3 theDatepicker2.Calendar. Date & Time Picker 64 bit How can I download Date & Time Picker for 64 bit I would like this control to be added to a VBA User Form. ![]() Label2.Caption = Format(theDatepicker2.EndDate, "dd.mm.yyyy" ) End Sub ' close userform Private Sub OKButton_Click() Me. Label1.Caption = Format(theDatepicker2.StartDate, "dd.mm.yyyy" ) Me. Label2.Caption = Format(theDatepicker2.EndDate, "dd.mm.yyyy" ) End Sub ' Datefield range setting, second date field Private Sub Label2_Click() theDatepicker2.ShowDialog Me. Label1.Caption = Format(theDatepicker2.StartDate, "dd.mm.yyyy" ) Me. The ActiveX control only ran on 32 bit systems, but this date picker class runs on any version of Excel both 32 and 64 bit. Because the code for the date picker is included in your workbook, you can distribute it and anyone using your workbook doesnt have to install any other files. ![]() Use form controls to gather data, then enter this data into a table on your worksheet. Learn how to create Excel forms for tasks like data entry. An easy to use VBA class, with examples to download in a workbook. Datefield.Caption = Format(theDatepicker.StartDate, "dd.mm.yyyy" ) End Sub ' Datefield range setting, first date field Private Sub Label1_Click() theDatepicker2.ShowDialog Me. A date picker is a control that lets users quickly enter dates in a Microsoft Office InfoPath form by clicking a small pop-up calendar. An Excel date picker (calendar) for all versions of Excel, both 32 and 64 bit. ![]() Dim theDatepicker2 As Object ' single Datefield setting Private Sub Datefield_Click() Dim theDatepicker As Object Set theDatepicker = CreateObject( "DatePicker.DatePicker" ) = 1 theDatepicker.ShowDialog Me. I am trying to insert a datepicker when clicking a cell in a range, but in office 365 64 bit, but I have only found a solution for 32 bit.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |