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