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
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