Solved: userform to populate the list box with values

[kevvukeka]

Hi All,

I am trying to develop a userform. Attached is the same. Col A- contains member IDs, Col B - Claim Numbers, Col C - Country, Col D - Amount.

I prepared a user form, which takes the input for member ID, based on the ID it will sum up the amount for "Brazil" under that member ID. This was working fine.

Now I got a new task to add a list box which will populate the claim numbers under the member ID given as input.

I couldnt use vlookup as its not just 1 value to populate.

How can i autopopulate the listbox with the claimnumbers based on the input given in memberiD textbox.

Attached file will give you the clear idea.


Thanks in advance

[p45cal]

Do you need a userform?
See pivot table in attached.

[kevvukeka]

Hi P45cal,

Thanks for you help.I need a listbox as I need to build my remaining code based on it. Basically the users will be inputting the member id. so I need to display only the data relevant to that member id.

[p45cal]

Try the attached.

[kevvukeka]

Thanks a Lot p45cal.. This is what I actually required thanks so much...