Maneesh Massey
Member
Hi,
I am working on a VBA application in Excel 2013 and have set up a UserForm in which I have a Combo Box and a Listbox below. The Combo Box contains a list of ID codes. I would like a user to be able to make a selection of an ID from the Combo Box and display all information pertaining to his/her ID number such as address, phone, email etc. in the Listbox below. The Listbox would pick up this information from a worksheet range. This should go into the Change event of the Combo Box. How can I do this?
Can someone please help me? Appreciate all help.
Kind Regards,
Maneesh
I am working on a VBA application in Excel 2013 and have set up a UserForm in which I have a Combo Box and a Listbox below. The Combo Box contains a list of ID codes. I would like a user to be able to make a selection of an ID from the Combo Box and display all information pertaining to his/her ID number such as address, phone, email etc. in the Listbox below. The Listbox would pick up this information from a worksheet range. This should go into the Change event of the Combo Box. How can I do this?
Can someone please help me? Appreciate all help.
Kind Regards,
Maneesh