Adding currency format to ListView columns

[lapot]

Hi all

I have a Userfrom with a List View, below code loads list view items from an excel sheet, it has 24 columns

how do I add currency format below code that List view columns 7,8,9,10,11,12,13,14 shows as currency

any help will be apricated

Please Login or Register  to view this content.

many thanks in advance

[ByteMarks]

Format the value before adding it.

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Same with the ListSubItems

[lapot]

thank you for your reply, I have added your suggestion, but it hasn't worked

Please Login or Register  to view this content.

[rorya]

The line in bold replaces the line below it.

[jindon]

If data in those columns is formatted as currency, try change all .Value to .Text

[lapot]

I tries this one and it didn't work either, sorry to be a pain

Please Login or Register  to view this content.

[lapot]

If data in those columns is formatted as currency, try change all .Value to .Text

only yellow highlighted should have currency values the others date or some references

Capture.PNG

[jindon]

I meant to say the data in those columns in the worksheet.

If the columns are formatted as you want to see on list view, .Text property should appear as what you see on the worksheet.

[lapot]

I meant to say the data in those columns in the worksheet.

If the columns are formatted as you want to see on list view, .Text property should appear as what you see on the worksheet.

This is how the excel sheet look behind the user form

Attachment 805564

[jindon]

Your attachement is invalid, so can not open.

[lapot]

Your attachement is invalid, so can not open.

sorry here it is again

Capture2.PNG

[jindon]

Did you change all the .Value property to .Text in the code posted in your initial post #1?

If so and doesn't work, I need to see your workbook.

[lapot]

here is the workbook

thanks

[jindon]

ListView control doen't seem to accept special characters.
So, if you can change it to ListBox, it is lot easier.

example

Please Login or Register  to view this content.

[lapot]

this code worked on ListView

thank you very much for your time nad Thank you to ByteMarks too

Please Login or Register  to view this content.

[jindon]

That was my attempt but it doesn't work here, so I didn't mention.

Perhaps it is the difference of local settings...

That's good if it is working at your end anyway.