Adding currency format to ListView columns

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

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

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

Please Login or Register  to view this content.

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

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

Please Login or Register  to view this content.

Originally Posted by jindon

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

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.

Originally Posted by 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.

This is how the excel sheet look behind the user form

Attachment 805564

Your attachement is invalid, so can not open.

Originally Posted by jindon

Your attachement is invalid, so can not open.

sorry here it is again

Capture2.PNG

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.

here is the workbook

thanks

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.

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.