Date Userform Alternative To Date Picker Control

%3CLINGO-SUB%20id%3D%22lingo-sub-2049764%22%20slang%3D%22en-US%22%3EDate%20Userform%20Alternative%20To%20Date%20Picker%20Control%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2049764%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20useful%20userform%20that%20it%20contains%20many%20features%20to%20quickly%20add%20date%20to%20the%20selected%20active%20cell.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Vba-date-form.gif%22%20style%3D%22width%3A%20394px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F245291i5F541268DF2B83BB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Vba-date-form.gif%22%20alt%3D%22Vba-date-form.gif%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20pre-selected%20column%20of%20the%20worksheet%20(column%20or%20columns%20can%20be%20selected%20with%20the%20codes%20that%20added%20to%20the%20Worksheet_BeforeDoubleClick%20procedure)%2C%20the%20year%2C%20month%20and%20days%20are%20sorted%20in%20the%20date%20userform%20that%20displayed%20by%20double-clicking%20on%20active%20cell.%20By%20clicking%20on%20the%20days%20listed%20as%20the%20buttons%2C%20the%20date%20is%20entered%20easily%20the%20date%20to%20active%20cell%20as%20dd.mm.yyyy%20or%20mm.dd.yyyy.%26nbsp%3B%3C%2FP%3E%3CP%3EDay%20and%20month%20names%20are%20generated%20according%20to%20the%20user's%20system%20language.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2Cif%20there%20is%20a%20date%20in%20the%20clicked%20cell%20%2C%20that%20date%20is%20displayed%20in%20the%20userform%20as%20year%2C%20month%20and%20day.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20details%20and%20download%20userform%20example%20%3A%20%3CA%20href%3D%22https%3A%2F%2Feksi30.com%2Fadd-date-to-cell-easily-with-excel-userform%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EExcel%20date%20userform%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2049764%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

I have created a useful userform that it contains many features to quickly add date to the selected active cell.

Vba-date-form.gif

 

In the pre-selected column of the worksheet (column or columns can be selected with the codes that added to the Worksheet_BeforeDoubleClick procedure), the year, month and days are sorted in the date userform that displayed by double-clicking on active cell. By clicking on the days listed as the buttons, the date is entered easily the date to active cell as dd.mm.yyyy or mm.dd.yyyy. 

Day and month names are generated according to the user's system language.

 

Also,if there is a date in the clicked cell , that date is displayed in the userform as year, month and day.

 

For details and download userform example : Excel date userform

0 Replies