I got sick and tired of the failure of the Microsoft Calendar from being made a part of my VBA Projects that I created a new kind of Data Entry Form for a Date entry. You can call it anything you want, but I decided to call it “frmCalendarDate” or “MonthView Form”. It looks like this image below:
Basically, the operation of the above is very simple and obvious, and has been inspired by a similar post I saw elsewhere around 15 years ago, but basically requires you to manually feed the year, month and day using the up-down coltrols provided, or you can enter them manually and the data appears in “The Selected Date” textbox, after which you can click the “Date is OK” button and get the date in a designated cell named as “frmCalendarDate” on any worksheet of your choice anywhere in the workbook. That is all there is to it, folks!! Like it? Follow my blog if you do, I am putting up numerous posts and will continue in the near future to do so. Cheers !!
CA Vikram Shankar Mathur
24-Apr-2022 | 10:52 Hours IST
You must be logged in to post a comment.