Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Format a ListBox column
Thanks for your input Pascal. No luck - it didn't change
the format of the ListBox. My problem again.... I have a 2 column ListBox 1st dates 2nd text. ListBox is populated from an array, itself populated from a 2 column range of cells in the WorkSheet. The 1st worksheet (dates) column is formatted in the English (GB) format "31/02/04" However the ListBox shows the dates in the American longer format "2/31/2004" (without the leading zero for the month) How do I format the ListBox to reproduce the dates as they were in the original source data. Any suggestions would be greatly appreciated. Don Bowyer |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Listbox format | Excel Discussion (Misc queries) | |||
format a listbox | Excel Discussion (Misc queries) | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Format columns in a ListBox? | Excel Programming | |||
listbox format... | Excel Programming |