I have a UserForm with a ComboBox populated from a list on an excel sheet.

When the user selects a value from this list I would like a further ComboBox to show a list of values based on the first ComboBox.

I want the process to be similar to the =INDIRECT function in Excel formula.

For example the user selects "Telephone" from the first box and the next box would only show a list of Telephones or the user selects "Computer" and the next box would show a list of Computers.

Thanks in advance