View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Juan Pablo González Juan Pablo González is offline
external usenet poster
 
Posts: 226
Default How to Format a ListBox column

How do you populate the listbox ?

--
Regards,

Juan Pablo González

"Don Bowyer" wrote in message
...
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