Creating a calendar in a cell for a date-picker

M

MarkieE

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
 
B

Bill Sharpe

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

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
 
Top