sprintswim71
09-05-2015, 07:21 AM
So I am creating a userform that has several dropdowns. The first drop down has the "Product" name. This first dropdown is basically the name of each tab that I want to go into.
The second drop down is "Test Types". Once the "Product" dropdown is selected. The second dropdown will autofill with the Types associated with that "Product". The user will then select the Test type and it will then auto fill the "Test Number" dropdown.
Does anyone know how you would write this in VBA code? I think it would be using a vlookup or indirect or even storing the Product dropdown value. I have attached photos below and the excel file.
14322
Thanks1432014321
The second drop down is "Test Types". Once the "Product" dropdown is selected. The second dropdown will autofill with the Types associated with that "Product". The user will then select the Test type and it will then auto fill the "Test Number" dropdown.
Does anyone know how you would write this in VBA code? I think it would be using a vlookup or indirect or even storing the Product dropdown value. I have attached photos below and the excel file.
14322
Thanks1432014321