PDA

View Full Version : Solved: userform to populate the list box with values



kevvukeka
06-09-2013, 09:54 AM
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
06-09-2013, 10:53 AM
Do you need a userform?
See pivot table in attached.

kevvukeka
06-09-2013, 11:34 PM
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
06-10-2013, 12:13 AM
Try the attached.

kevvukeka
06-10-2013, 04:14 AM
Thanks a Lot p45cal.. This is what I actually required thanks so much...