Creating a Calendar to select a date

[dpaton05]

I have an excel table with the date to be in column A. I want to make a small calendar appear and select the date from it to insert the date into the cell for each row. I found this possibly useful website, but I do not know how to implement it.

Google Sites: Sign-in

Access Google Sites with a personal Google account or Google Workspace account (for business use).

sites.google.com

Could someone help me please, either with this site or with a way I could get this done?

Thanks

 

[KevCarter]

Dave if you need to find your XLStart folder
Open your VBA then press CTRL + G to open the immediates wndow, now copy this into the immediates window

? application.StartupPath

Then press enter. Your path to the folder will be shown

Good tip, I learned something there as well. Thank you!

 

[dpaton05]

Now I have the date picker inserted but I do not know how to make the little calendar appear when I have the date field selected.

 

[KevCarter]

Now I have the date picker inserted but I do not know how to make the little calendar appear when I have the date field selected.

View attachment 27066

I no longer use it, but if I recall, it shows automatically when you select a cell with a valid date. Is your date entered as text, or is it a valid date?

 

[dpaton05]

I just saved it, closed and reopened my workbook and it now works as described, thankyou,

 

[KevCarter]

I just saved it, closed and reopened my workbook and it now works as described, thankyou,

Good deal. I hope it solves your issue!