Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date-Format of Dropdown-Combo is integer
When I use a Dropdown-Combo listing dates in an Excel-Userform , the
choosen date is formatted into integer instead of date (38048 instead of 02.03.2004), when the dropdown-combo collapses. How can I format into date? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date-Format of Dropdown-Combo is integer
One easy way is to load the combobox with Strings rather than using the
rowsource properties. for each cell in Worksheets("Sheet1").Range("A1:A10") userform1.combobox1.AddItem cell.Text Next You can do this in the Initialize event of the userform. -- Regards, Tom Ogilvy "goa" wrote in message m... When I use a Dropdown-Combo listing dates in an Excel-Userform , the choosen date is formatted into integer instead of date (38048 instead of 02.03.2004), when the dropdown-combo collapses. How can I format into date? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo Box dropdown data | Excel Discussion (Misc queries) | |||
Combo Box / Dropdown Box HELP!!!! | Excel Discussion (Misc queries) | |||
I want my combo box to return a date format instead of a number? | Excel Discussion (Misc queries) | |||
keep date format in a Combo box | Excel Worksheet Functions | |||
Date format when using combo box | Excel Programming |