| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
converting date combobox to show date
Hi Bucky F.
How about the calendar control? Dan |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting hijri date to gregorian date | Excel Discussion (Misc queries) | |||
| Converting a year date into a specific day date | Charts and Charting in Excel | |||
| Coding to show first _weekday_ prior to a date, when date calculation happens to fall on weekend? | Excel Programming | |||
| converting date from a textbox to a date format | Excel Programming | |||
| Converting a string date into a Excel Date | Excel Programming | |||
Hybrid Mode
