How Format a List Box

  • Thread starter Thread starter don bowyer
  • Start date Start date
D

don bowyer

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
 
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
 
Back
Top