I need a popup calendar that is called from a CmdButton that will return the
value chosen to a varable.
The needed format is
..NumberFormat = "m/d/yyyy;@"

Thanks

There are several ways to do it, the one you choose will depend on how
exactly it is implemented. A standard button could launch a user form with a
calendar on it, set the click event to
ActiveCell.Value = Calendar1.Month & "/" & Calendar1.Day & "/" &
Calendar1.Year

or, as in my xl2003 on the worksheet toolbox you can add a microsoft date
time picker.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"treasuresflemar" wrote:

> I need a popup calendar that is called from a CmdButton that will return the
> value chosen to a varable.
> The needed format is
> ..NumberFormat = "m/d/yyyy;@"
>
> Thanks
>
>
>
>