Format in Combobox / Listbox

[CobraLAD]

Hi

I have on a sheet data from column A - E

000001 | ACC001 | Account Name | 25 Mar 2008 | R 20,560.00


when I list in a Combobox with 5 columns it display like this

1 | ACC001 | Account Name | 3/25/2008 | 20560

Is there a way to display exactly as it is on the sheet. I am using this code

Please Login or Register  to view this content.

I have tried a ListBox as well, same thing

[mikerickson]

The .Text property of the cells, which returns what is displayed rather than the underlying value, is needed. Unfortunatly, it won't bulk load like .Value, so a loading loop is needed.

(Mac OS10.5 Excel 2004)

Please Login or Register  to view this content.

[jindon]

try

Please Login or Register  to view this content.