I have a user form with a combo box that opens to select dates from a list(
would like a pop up calendar dont know how in vba) anyway, this box show the
date but moving to another box it chages to the number value. need code to
keep it as a date thanks
--
Bucky F

In the VBE with yoru form active right click on the Control Toolbox and
select Additional Controls. Add the DT Picker to the Control Toolbox. That
control should work for you...
--
HTH...

Jim Thomlinson


"willfeld" wrote:

> I have a user form with a combo box that opens to select dates from a list(
> would like a pop up calendar dont know how in vba) anyway, this box show the
> date but moving to another box it chages to the number value. need code to
> keep it as a date thanks
> --
> Bucky F

the date picker does not appear in the additional controls although i have
used it in a spreadsheet could it have a different name?
--
Bucky F


"Jim Thomlinson" wrote:

> In the VBE with yoru form active right click on the Control Toolbox and
> select Additional Controls. Add the DT Picker to the Control Toolbox. That
> control should work for you...
> --
> HTH...
>
> Jim Thomlinson
>
>
> "willfeld" wrote:
>
> > I have a user form with a combo box that opens to select dates from a list(
> > would like a pop up calendar dont know how in vba) anyway, this box show the
> > date but moving to another box it chages to the number value. need code to
> > keep it as a date thanks
> > --
> > Bucky F

Hi Bucky F.

How about the calendar control?

Dan

On my system, it is called...

Microsoft Date and Time Picker Control 6.0

Rick


"willfeld" <(E-Mail Removed)> wrote in message
news:E9225D15-00C5-4D8D-8F67-(E-Mail Removed)...
> the date picker does not appear in the additional controls although i
> have
> used it in a spreadsheet could it have a different name?
> --
> Bucky F
>
>
> "Jim Thomlinson" wrote:
>
>> In the VBE with yoru form active right click on the Control Toolbox and
>> select Additional Controls. Add the DT Picker to the Control Toolbox.
>> That
>> control should work for you...
>> --
>> HTH...
>>
>> Jim Thomlinson
>>
>>
>> "willfeld" wrote:
>>
>> > I have a user form with a combo box that opens to select dates from a
>> > list(
>> > would like a pop up calendar dont know how in vba) anyway, this box
>> > show the
>> > date but moving to another box it chages to the number value. need
>> > code to
>> > keep it as a date thanks
>> > --
>> > Bucky F