• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Display data in Listbox based on Combo Box selection

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
 
Hi, Maneesh Massey!
Consider uploading a sample file (including manual examples of desired output if applicable), it'd be very useful for those who read this and might be able to help you. Thank you.
Regards!
 
Back
Top