Date picker without using addins and active control in forms

[dummy777]

Is there a way on how to create date picker without using addins and active control in forms?

Is it possible to create using data validation but in calendar format and not like list of dates?

Also if there is a vba codes just like a calendar? Tia.

[Mumps1]

Try the attached file. When you click an any cell in column A, a calendar will pop up so you can choose a date which will be placed in the selected cell. If you right click on the tab name and click "View Code", you can change the target range to suit your needs.

[dummy777]

Thank you very much for this calendar control. Is there any tutorial on how to build that form?

[Mumps1]

You are very welcome. To be honest, I didn't write that code. I found it after doing a search years ago and I can't even remember where I found it so I could give the author credit.

[torachan]

Always good to see code developed.
However why not use tools at your disposal.
MonthView or DTPicker usually work well if installed properly.
One or other of the attached will always work.
Click in range A2:A100, both have minimal coding requirements.
torachan.

[dummy777]

Thank you for this, but my excel doesn't have date picker. Microsoft windows common control and windows monthview control in references and additional control is grayed out.

[torachan]

is your problem the same as the OP ?

https://www.excelforum.com/excel-pro...el-2019-a.html

[dummy777]

Yes! Thank you for the link.

[VikkiD]

Hi. I just came across your post and I believe it's the solution I am looking for however I am not real familiar with VBA and am unsure how to get into my workbook. I see there are 2 modules with script I'm assuming I need them both for it to work?

Thank you.

[Mumps1]

If you are referring to the file I attached in Post #2, the file includes a userform that would have to be copied into your workbook and also a macro in the worksheet code module for Sheet1 which would have to be copied into the worksheet code module in your workbook. The macro is designed to bring up the calendar when you click on any cell in column A. This can be changed to any column or range.

[torachan]

Hi VikkiD, look back at your previous posting,

https://www.excelforum.com/excel-pro...ml#post5667072

[VikkiD]

Yes- thank you. I am getting assistance- wasn't sure if that thread was still being followed.