How to add the value of columns to listview

[Nader]

How to add the values of 8 columns to listview with the head of each columns.

[Bob Phillips]

Put the data in a worksheet range, with the headings and set the rowSource property of the listbox to that range but not the headings, set the ColumnCount property to your number of columns, and the ColumnHeads property to True.

[Nader]

I tried this code but didn't succeed


ListView1.RowSource = Sheets(1).Range("a1:d6")
ListView1.ColumnHeaders = True

By the way there is no columnCount property.

[Bob Phillips]

Oops I was thinking ListBox not ListView.

[Nader]

Here is the code for one row in column 1


With ListView1
.View = lvwReport
With .ColumnHeaders
.Clear
.Add , , "First column", 100
End With
.ListItems.Add , , Sheets(1).Range("A1")
End With

how to load all item in the column 1

[lifeson]

How to add the values of 8 columns to listview with the head of each columns.

Unless the names of the columns are going to change, its much easier to use the columnheaders tool on the listview custom control