| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UK date format and combo box
Another annoying UK date format question I am afraid - Using Excel 2000 and
2002 (two versions running on office PCs) I have a combo box list populated from a series in a workseet using this code : ComboBox1.List = ThisWorkbook.Worksheets("Lists").Range("A30:A395") .Value (the Range is a list of dates in format DD/MM/YYYY.) All settings are to UK date format. Yesterday the list appeared in the combobox in UK date format - today it is in US format (MM/DD/YYYY). Grateful if anyone can suggest how I can force Excel to show the list in the UK date format - and keep it that way! TIA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format a combo box to show mmm-yyyy format | 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 of Dropdown-Combo is integer | Excel Programming | |||
| Date format when using combo box | Excel Programming | |||
Threaded Mode
