I want to give a user the ability to pick a date in a column of cells by
using a small, drop-down calendar? Data Validation doesn't give this as an
option-it only allows choosing dates between a range entered as free-text.

Any help is appreciated.

Thank you.

Mark

You can insert a calendar control on a user form when working with
Excel's VBA. You'll need to right click on the VBA Toolbox, select Add
Control and scroll down to Calendar control.

Bill

"MarkieE" wrote in message
...
I want to give a user the ability to pick a date in a column of cells by
using a small, drop-down calendar? Data Validation doesn't give this as
an
option-it only allows choosing dates between a range entered as
free-text.

Any help is appreciated.

Thank you.

Mark