Date picker calendar

**dori2o** · 12-08-2017, 07:25 AM

I use a date picker calendar in one of the workbooks I have which is accessed via a Userform that users enter data into which is then recorded on the spreadsheet.

I have been asked to update another spreadsheet that is used by management to record successes, promotions, etc as part of my employers Engagement with Staff processes.

The first column of the spreadsheet is a Date column. I have been asked whether it is possible to have a date picker calendar appear whenever a cell in this column is accessed to input the date?

Any help and advice as always much appreciated.

**ranman256** · 12-08-2017, 08:51 AM

date picker is a text box for forms.
but in worksheets, theres no need since EVERY cell is a textbox and you wouldnt want to embed hundreds of these on a sheet.

**dori2o** · 12-08-2017, 10:35 AM

All sorted.

Created a date picker calendar on a userform. This is opened each time a cell in Col A is selected.

Date is entered in active cell in text format (mmmmmmmmmm).

Just what I needed.

Thanks for the help and advice.