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?      
 

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?      
>  
>