Formatting data in a listbox

[KRAND]

Hi y'all,

I am populating a listbox with 5 columns using this code:

Please Login or Register  to view this content.

It works fine, however the formatting is ugly. I would like column 1 & 5 to be a date DD-MM-YYYY and column 2-4 to be number with commastyle (x.xxx,xx).

Is this possible?

Thanks for your time!!

Kind regards
KRAND

[davegugg]

I'd guess that you lose your formatting when you put the cell range into a variant variable. Can you do it like this instead?

Please Login or Register  to view this content.

Note: this may affect whether your list is dynamically updated as those cells change.

[KRAND]

Hi Dave,

Thanks for your answer.

I could not get your code working. But you where right about the formatting being killed by the Variant definition.

I found a way to "cheat" the code. I formattet all the data to text with a normal funktion: eg. =Text(B2; #.###).

Doing this I now get formattet data in my ListBox1.

THank you for your time!

Kind Regards
KRAND