I’m creating an order form with a couple dozen products – and each product can be produced in 4 different colors. Each product in each color has a different product code. (And assume each user will only want to order products in one color)
I’d like to have a User Form in excel where the user will be able to select which color they would like to order from a group of 4 option buttons. When a button is selected, and the user clicks “OK” I’d then like the products codes associated with that color to populate on the order from. (The form visible to the user and a full list of all [hidden] product codes could be on the same tab of the workbook)
Is this a logical setup, or is there a more simple way to do it? If this is the best approach, any assistance on the code (or reference to another existing post) for the option buttons would greatly appreciated!! A simple screenshot is attached in a word document.
Thanks in advance,
C