Hi Kvenku,

Thank you again for the information. But i have a question?
I tried in listview for changing the font color for each row.

for example:
1st row is blue color - works fine
2nd row in green color - 1st row and 2nd row are in green color.

So. only one color can be done in listview. I need to maintain atleast
2 colors in listview at a time.

ListView1.ListItems(0).ForeColor = vbBlue
ListView1.ListItems(1).ForeColor = vbGreen

For sorting can you give me some example of which column in sorted and
in what order.

It's not automatic. You'd have to handle the click event for the column
header, sort the list and change the caption of the column header to
match.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.ie