Need help populating second combobox based on value in first

[Patrick3001]

Hello everyone - first time here.

I've got a userform that becomes visable when the workbook opens, and on this form I require 2 comboboxes, the first must allow the user to select a value from column A:A on sheet1. I would then like combobox 2 to only show the values in column B:B on sheet 1 that apply, allowing one of these to be selected.

I'm at a point where I've got the boxes populating with all values, but have no idea how to make only valid combinations possible.

For example if the data was:

Column A Column B
A 1
A 2
A 3
B 4
B 5
B 6

...I would only like options 4,5,6 to be available in combobox 2 if "A" is selected in combobox 1.

Hope this is all clear.

Thanks in advance.

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

This demonstrates one way using Listboxes, but can easily be applied to ComboBoxes

[Leith Ross]

Hello Patrick3001,

The following is from the attached workbook. This workbook is based on your ComboBox question. The first ComboBox determines has "A" and "B". The selection from this ComboBox loads the second ComboBox with the contents of that of that column. The code determines the size of the column to be loaded. This allows for the ranges to dynamic and any changes to the worksheet are reflected on the UserForm.

UserForm Code

Please Login or Register  to view this content.