Excel-VBA - Eingabe eines Kalenderdatums

[Translate to English:] Demo eines Klassenmoduls, das die Datumseingabe mit der Maus ermöglicht, ohne Verwendung von ActiveX- oder Formularsteuerelementen.

Entry of a date using a pop-up calendar in the Excel worksheet

Entry of a date

When your hand rests on the mouse while you work on an Excel workbook, you don't like to lift your hand on the keyboard to enter a date. QRS has developed a module for date entry without the use of Active-X oder UserForm controls. The pop-up calendar is displayed in the specified worksheet range. Previous values are restored after finishing or canceling the entry.

Settings

Besides the specification of the calendar display range, an Auto-OK may be set, which considers the entry as done after the calendar date was clicked, thus saving the click on the OK cell.

Demo video

The video shows the calling of the pop-Up calendar by clickin on a cell button, navigation through years and months and finishing the entry by selecting a calendar day.

 

Comments and Responses

×

Name is required!

Enter valid name

Valid email is required!

Enter valid email address

Comment is required!

Be the First to Comment
Top