does excel allow the user to select a date from a pop-up?

[jake.peterson]

I formatted a cell as a date but somehow people still manage to mess it up.
Is there a pop-up calendar that appears when the user clicks on a cell?

 

[dmt32]

hi,
have a look here:VBA Tips: A Pop-up Calendar for Excel
you can download example which may do what you want.

Alternatively, if you don't want to use a macro solution - then could consider having a range of dates in a data validation list.

Dave

 

[jake.peterson]

Thank you dmt32