converting date combobox to show date
 

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

converting date combobox to show date
 

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

converting date combobox to show date
 

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

converting date combobox to show date
 

Hi Bucky F.

How about the calendar control?

Dan

converting date combobox to show date
 

On my system, it is called...

Microsoft Date and Time Picker Control 6.0

Rick


"willfeld" wrote in message
...
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