Listview add an index column at form initialization

[BigDaddy01]

Hello,


I have a form I developed in Excel 2010 that has a Listview control and is populated from a sheet with 20 columns and 396 rows. I want to have and Index column that gets populated with row numbers at UserForm_Initialize(). The index column populates when I do a search using a combobox, textbox and a command button with the following code, but after working on it all day I cannot find a solution to load the index when the userform initializes. Also I add a column for the index during initialization (code below). Any help would be extremely appreciated.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[BigDaddy01]

<bump> Still working on it, not making any progress.

BigD

[jaslake]

Hi BigD

Welcome to the Forum!!!

I've worked with ListView a bit and have done as I believe you're describing (capture a Row Reference). However, I don't understand this...the Index simply does not exist upon Initialization...

I cannot find a solution to load the index when the userform initializes

or this...

'THIS WORKS BUT ONLY AFTER SEARCH CRITERIA IS RETURNED

There is no Row Reference until the Search Criteria is returned, so, you have me a bit confused.

Please attach a sample workbook the Structure of which is the same as your actual workbook.

INCLUDE ANY CODE YOU'RE USING OR HAVE TRIED.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

[BigDaddy01]

Hi jaslake,

Thank you for the reply. I was able to get Listview to load the Index values into the first column in the UserForm_Initialize about 1/2 an hour ago, however now I can't get the list to display the data in columns. Its either list is populated with data and no Index or Index and no data. The application is too large to post and contains company data. Here is were I'm at with the Initialization. It appears it will work, its just getting it set up right.

BigD

Please Login or Register  to view this content.

[jaslake]

Hi BigD

You can zip the File and attach it if you wish.

Alternately, you can Email the File so I can look at it...your choice.

[BigDaddy01]

Hi jaslake,

I made a test form to show what is happening and it is attached. It's close, but still needs something.

BigD






Post Edit: This File contains the search operation

[jaslake]

Hi BigD

In the attached I've replaced these lines of Code...

Please Login or Register  to view this content.

with this...

Please Login or Register  to view this content.

Let me know of issues.

[BigDaddy01]

Hi jaslake,

It works!!!

That is just great, thank you so much for your time.

One thing if anyone plans on using this make sure the SORT property of ListView is set to FALSE or else the first time the form is displayed it will not be in order. From what I've read it's because ListView sorts Alphanumerical and not Numerical on the first column.

Thanks again to jaslake

BigD

[jaslake]

You're welcome...glad I could help.

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.