VBA Date picker or calendar in Inputbox?

[AlbertPietens]

Hello,

I want to create a series of inputboxes to ask questions to get the information I need to fill a row in my excelsheet.

One of the question is asking the date of a transaction. I now use the code below to enter a date. Is it possible to add a calander oor date picker in an inputbox to let me click the right date?

Code I use now:

Dim [I]date[/I] As Date
date = inputbox("enter date")
Range("A6").End(xlDown).Offset(1, 0).Value = Date

 

[Yongle]

Have you seen this thread ?
- it contains a link to (what appears to be) a decent date picker although I have not tested it personally
- you may need to use a simple userform (rather than an input box)