How Format a List Box
 

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

How Format a List Box
 

Hello Don
Use the Format function ie:
Format(YourItem,"DD/MM/YY")
HTH
Regards
Pascal

"don bowyer" a écrit dans le message de news:
...
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

How Format a List Box
 

Thanks for the input. I tried it but it made no
difference. The ListBox format still comes up with the
wrong (US) format.
Regards Don
-----Original Message-----
Hello Don
Use the Format function ie:
Format(YourItem,"DD/MM/YY")
HTH
Regards
Pascal

"don bowyer" a écrit dans le
message de news:
...
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


.