Easy Way To Enter Date Into Active Cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2639005%22%20slang%3D%22en-US%22%3EEasy%20Way%20To%20Enter%20Date%20Into%20Active%20Cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2639005%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Userform_to_add_date.gif%22%20style%3D%22width%3A%20759px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F302626iA6626AE13EE64D1A%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Userform_to_add_date.gif%22%20alt%3D%22Userform_to_add_date.gif%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThe%20calendar%20form%20is%20displayed%20when%20it%20is%20double-clicked%20on%20any%20cell%20on%20the%20worksheet.Months%20are%20listed%20in%20the%20combobox%20control%20according%20to%20the%20user's%20system%20language%20starting%20from%20the%20month%20on%20the%20userform%20caption%20.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EThe%20ControlTipText%20value%20of%20the%20clicked%20button%20on%20the%20userform%20is%20added%20to%20the%20active%20cell%20as%20a%20date.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ESource%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%20calendar%20userform%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2639005%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Userform_to_add_date.gif

 

The calendar form is displayed when it is double-clicked on any cell on the worksheet.Months are listed in the combobox control according to the user's system language starting from the month on the userform caption .

The ControlTipText value of the clicked button on the userform is added to the active cell as a date.

 

Source : Excel calendar userform

1 Reply

@kadirguler 

 

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. For example, you can use a date picker to collect birth dates from people on an insurance form. You can also use a date picker to display preset dates, such as the current date.

 

Insert a date picker