Populating ListView control

I'm trying to populate a listview control, i have an advanced search performed on a 20000 item excel list (using vba) and the results are sent to sheet1, i want to have this range viewed in a listview control (rather than listbox, because people can change the colmun widths dynamically). To populate the listview box i have this:

Please Login or Register  to view this content.

But i get 'object doesnt support this method or property' at the do until line, i cant work out why..

Can anybody help, or is there a better method to do this?

Thanks in advance,

Jack

Thanks for the quick response guys,

Pike, I gave the article a look at, it more focused on populating with userform data rather than an excel sheet, thankyou though!

Andy, il give your code a go and get back to you with some feedback.. thankyou also.

Cheers
Jack

hi guys,

again, thakyou for helping so quickly!

Andy, your code only runs when remove:

Please Login or Register  to view this content.

else i get an object required error, when i remove it i get the listview box to populate but you cannot see an item in the list? i can see the scroll bar moving, but nothing in the box.. how strange.. what am i doing wrong?

D_rennie, your code works however i get all the items from my first column set up in a grid view kind of thing, rather than list.. how do i stop this

You would think trying to show a range in an unedittable form, with adjustable columns (autofit) would be simple..

I have about 25 different columns of info for each row. I made it work with a listbox fine, however, because the order of the colmuns can change, setting fixed columns width wasnt an option. Im getting lost!

thanks for all your help,

Jack

I just got D_rennie's working, i didnt quite understand all the properties for listview!

Is they any way of not having to type the column titles withing the code,. instead just take them from row A on sheet1? It means that when people come an edit the data (i.e. the column headings) the tool keep its self up to date..

Is it possible to add column of info if row A has text in, i.e. dynamic range? Keep looking along until theres no more data to be put into the table.. its means that if people add extra columns in the future then, again, the tool keeps it self up to date? i managed it with the listbox.. but listview is entirely different..

Thankyou so much in advance... i coudlnt of done this alone!

Jack

Andy,

That is amazing! I've been trying all day to achieve exactly that! thankyou!

Couple of things though, can i autosize columns at userform_initialisation? And is there a method of removing columns if there is nothing inside of them exept the header?

The database is a list of standard nuts, bolts and washers etc. When I search for washers i still have the column 'thread length' on display but with no data within it. Vice versa with a bolt search, i have 'thickness', reffering to washers, but with no infomation within it. Is there a way of hiding these columns if theres no data filling them?

Thankyou so much for all of this, i was totally lost.. pulling my hair out all day over this and you saved me!

Cheers
Jack

Andy,

You are actually a genius, how do you know his stuff? its incredible!
Thankyou so much again.. I've actually learnt a huge amount by studying your code. That worked a treat.

Is there any way to format the first column, i.e. the first column is numerical but is formatted to 6 digits (padded with zeros) 1 is 000001 etc. Is there a way of making the numbers appear like this in the listview column?

Thanks again
Jack

Works like a charm, thankyou Andy!

Hi
How to change the listView only show The Data from A16:I48
And the header start from column A to I