ComboBox VB help

******Well I just noticed that the topic below me is the same question.... However I am needing to do this in a user form... I do not know if that changes the answer given to the other poster.. thanks *********

Hello... I think this should be pretty simple but I do not know enough VB to figure it out... (I know how to create combo boxes from the numerous guides online... however I am not sure how to do special coding to one)


I am wanting to have two comboBoxes on this user form..

The first drop down box I want to have different store names.

The second drop down box I want it to display a list of items from a store that was selected in the first drop down box.

My guess is I would have the regular code for the first combobox and then an if statement to create the second combo box.

Thanks. If I need to be more clear somewhere please let me know... But this is pretty straight forward .. I would think.

It depends where the data is & how it is set out. Attach an example workbook

Here is a small example of how it could be done, notice the named ranges.