filling listbox from userform combobox problem

hi
iam having bit of problem filling a multiple listbox ,my combobox fills all textboxes ok but can not seem to get listbox working,the idea should be to pick number from combobox and populate listbox,say d101 is picked there can be more than one d101, so you can pick one populated in listbox ,which then sends to textboxes the one you picked,hope that makes sense,any help in direction to take please
cheers colin

Is the combination of Unit and plant number a unique identifier?

If you want to populate the listbox based on the choice in the combobo why is the code to populate it in the form's Initialize event.

The code should go in the combobox change event, and the code to populate the textboxes should go in the listbox's change or (double) click event.

in post #1

say d101 is picked there can be more than one d101

and then

the plant number is unique

now I am confused as your example file shows no duplicate plant numbers.

You have a combobox with unique idenfiers (listing plant number), what was the sense of the listbox again?

Colin

What exactly do you have now?

try VlookupLIFTPLAN_1.xlsm

subs changed:

Please Login or Register  to view this content.

Colin

Populate the textboxes from the listbox, not the sheet.

Please Login or Register  to view this content.

You are totally correct Norie.

No idea why I was checking the sheet and then taking the listbox values, does not make sense at all.

tehneXus

I was totally confused trying to figure out how you were correctly populating the textboxes.

I stepped through the code multiple times until I realised you were using the Listtbox.

Colin

You can't use AddItem when there are more than 9 columns.

What you can do is create an array with the data for the listbox and then use List to populate.

Colin

Its quite straightforward really.

Something like this very rough code.

Please Login or Register  to view this content.

This works but the column widths aren't right.

Please Login or Register  to view this content.

That code would replace the code in the combobox change event that is populating the combobox.

Please Login or Register  to view this content.

Remember though, I've not got the column widths, or possibly not even the columns to be displayed, quite right.

You'll need to fix that yourself, or give more details.