UserForm listbox/combobox

Hey all,

I am trying to construct a UserForm to have a listbox that is dependent on the contents of a combobox. I have found a few posts which explain the process that always leave me with code to debug!

I have attached an example of what I’m trying to achieve. Worksheet 1 has the lists and worksheet 2 has a button to open the form. The form has a button to close it and the combo/list boxes on it.

The bits which I haven’t done which always get me are naming the list ranges and adding the code to buttons… …any help with this one is greatly appreciated!!

Many thanks,

Adele

Please Login or Register  to view this content.

Hi adeleex, try the attached workbook and let me know if it meets your requirements.

Try this next upload.

You only need 2 lines of code:

Please Login or Register  to view this content.

Alternative method:

Please Login or Register  to view this content.

Cfr. the attachment

@Mordred

Never use 'additem' to populate (i.e. >1 ) a listbox/combobox

snb, this works a treat, even I can understand the coding & added funky colour too haha... thankyou!! xx