I am very new to VBA so any help would be great! I have a data set in another file that has 3 col with thousands of rows. In all 3 columns I have values that are not unique. I need 3 combo-boxes. In the 1st combo box, I need to be able to choose what is in column "A" (bringing back unique values) for the diff. types of business units I have. Next, depending on the bus. unit, I need combo box 2 to allow you to select a specific customer (depending on the business unit you have selected - column B in data set). Finally, in combo box 3, I need the user to be able to select the different cost centers that exist for a given customer (column C in data set). I need unique values for all 3 col.
I think I have combo box 1 with the following code:
Could someone help me figure out how to do combo box 2 and three? Any help is greatly appreciate.
Thank you!
Bookmarks