I have a pair of dependent ComboBoxes in a user form. ComboBox1 and ComboBox2. ComboBox2 is dependent on ComboBox1.
This pair appears several times in the user form in the form of (ComboBox3 and ComboBox4), (ComboBox5 and ComboBox6), ……..etc. next to a text box which contains a description of machinery condition. The user has to use the ComboBoxes only in the case of a failure to the piece of machinery.
I am currently using in the attachment.
This code is sufficient only if there is a single pair of dependent ComboBoxes. Is there way to extend this code for all ComboBoxes such that it is called only when a pair of ComboBoxes is used.
Thank you in advance.