Put the workbook in design mode by clicking on the design button on the
control toolbox (first icon that looks like a triangle, pencil and ruler)

Right click on the Date Picker and select Properties

Add a cell reference to the Linked Cell property.
--
HTH...

Jim Thomlinson


"Norm" wrote:

Thanks Jim
This is what I needed but I am having a problem connect the date to a cell
that will work with the VLOOKUP attached
Can this date be tied to the cell?



You can try the Microsoft Date and Time Picker control.

Add the Control Toolbox menu to your toolbars. Select the last button that
looks like a hammer and wrench. Select the Microsoft Date and Time Picker
Control. Add that to your sheet.


--
HTH...

Jim Thomlinson


"Norm" wrote:

Is there a pop up calender that can be embedded when sharing or emailing
worksheets?
Thanks
Was this post helpful to you?