Insert date picker into 3 columns

Hi everyone, I have been looking at some search results on adding a calendar picker to 3 columns of a worksheet I'm creating, and can't seem to find a solid answer to what I'm looking to do. I can't possibly take the time to add the date picker to each individual cell, so I'm hoping there is an easier way to do this.

What I'm hoping to do is fill cells F2:F200, G2:G200, and H2:H200 with a calendar picker. I'd prefer the calendar picker to not appear in these cells if the rest of each row is blank. The calendar picker field should be blank in each cell by default. I'm fine with doing this via VBA, I just need a practical, relatively simple solution for this, please. I'm using Excel 2013. Thanks a bunch in advance!

-Andrew

I tend not to use date picker supplied by MS, for backward compatibility purpose (many clients still use 2003).

You can use one of custom date pickers out there and adopt to your need.

See attached for example of Custom Calendar form. This one uses xlVeryHidden sheet named "Calendar" to populate the userform.

Then you can use Worksheet_BeforeDoubleClick event to show the userform on column(s) of your choice. Sample code below.

Please Login or Register  to view this content.