UserForm ComboBox linked values

Hello

This is probably quite simple but I can't quite get mine to work.

I have a userform which at the moment has 2 comboboxes (soon to be 3 once I sort this code). The second box will be determined upon the selection of the first.

The first combobox currently equals a cell reference by way of 'RowSource': PLHeading1

This being: Turnover, Direct Costs and Overheads


When one is selected I would like a list of other names to appear in combobox 2

Here is my code:

Please Login or Register  to view this content.

Could someone explain why this doesn't work?

For reference, B4:B6 = cell reference PLTurnover2 B7:B11 = PLDirectCosts2 B12:B28 = PLOverheads2

Works perfectly thanks!

Also, is it possible for the value of a combobox to equal a cell?

For example, combobox1 could equal "Turnover" but elsewhere in the workbook the user can change the name of this if they like, so what if they change it to "Sales"?

Combobox1 value = worksheet "Account Names" cell A5

Thanks

Or could the value of combobox 1 equal the cell reference e.g. combobox 1 = "Heading" and so within "Heading" you have your Turnover, Direct Costs and Overheads, all of which can change name via another sheet.

I think this would be far more efficient?

I just realised it can't equal a cell reference because the combobox will only have values from that cell reference, therefore the following combobox wouldn't know what values to input into the drop down.

I think making it equal a cell itself is the best option

I got it working like this, which if the heading names change, the userform still works:

Please Login or Register  to view this content.

Thanks for your help! Rep given.