listbox double click not allowing selection of upto last 4 items

[JamesT1]

Good Morning All

I have a listbox that shows variable selected information in 9 columns.

The list can be anywhere from 1 to hundred's of lines...

Using the macro below when the user double clicks one of the lines then the information is moved to 9 textboxes.....

The problem I'm having is:.... it will not allow the user to select any of the last 4 lines in the listbox.....

Taking it line by line.. From Rec1 to Rec 5 everything is OK... when Rec 6 is added it won't allow the last line to be selected.. Rec 7 last 2 lines,, Rec 8 last 3 line and Rec 9 last 4 lines....

If the list only has 4 or less lines then it won't allow any to be selected

Appreciate any help

Many thanks

Jim

Please Login or Register  to view this content.

[Andy Pope]

I can not replicate the problem you describe. Can you book example file.

Any reason why the last 8 rows of the listbox are excluded?

Also you have a Exit for in the loop, so only the first selected row is displayed. So do you really need to allow the user to select multiple rows?
If not make the listbox single select and you can use the ListIndex property, rather than looping.

[JamesT1]

Hi Andy

Many thanks for your reply....

I didn't know the last 8 rows of the listbox were excluded,, could that explain the issues I'm having..

I have attached a workbook with the Userform..

The idea is the user will open the form and type in the surname of the person that updating the records for... the list could be just 1 line or multiple lines if the user has more than 1 record... or more staff with the same surname.. etc

The user should then double click on the line for the required information to update the text/combo boxes this would then allow that record to be updated

Many thanks

jim

[Andy Pope]

Revise the resultsList named range so it does not have empty rows

=OFFSET(Data!$Q$8,0,0,COUNTA(Data!$Q:$Q)-4,9)

The change to the code would be

Please Login or Register  to view this content.

The property ListCount tells you how many rows of data are in the listbox. As the List is zero based you need to subtract 1.
You are currently subtracting 9, probably confusing that with the number of columns.

Other than that all the textboxes appear to be updating correctly when you double click a row in the listbox

[JamesT1]

Andy

you are right, I was thinking the listCount was the same as the number of Columns

Now works exactly as I wanted it

many thanks for your help

Jim