sprintswim711
New Member
- Joined
- Sep 4, 2015
- Messages
- 2
Hi there,
I have taken on a project to automate a excel workbook. This worbook has multiple sheets. Each sheet is name the product name. Within that sheet it has the product name, a "Test Type" , a "Test Number", a "Status", and person who has looked at the product.
I have created a userform with all the product names in a drop down menu. I would like to now have those over comb-boxes autofilled in. So after selecting a Product, all the Test Types show up. After you select a Test Type, all the possible test numbers show up that are of the same product and test type. Once you select the test number, both the Status and person who looked at the product appear in the dropdown box (values for both have been already added).
Can someone direct me as to how to autopopulate dropdowns. Is it vlookup after update or something like that?
I have taken on a project to automate a excel workbook. This worbook has multiple sheets. Each sheet is name the product name. Within that sheet it has the product name, a "Test Type" , a "Test Number", a "Status", and person who has looked at the product.
I have created a userform with all the product names in a drop down menu. I would like to now have those over comb-boxes autofilled in. So after selecting a Product, all the Test Types show up. After you select a Test Type, all the possible test numbers show up that are of the same product and test type. Once you select the test number, both the Status and person who looked at the product appear in the dropdown box (values for both have been already added).
Can someone direct me as to how to autopopulate dropdowns. Is it vlookup after update or something like that?
