Dependent combobox to show values from a table column

hello i have been trying to get a combobox to show items from a table in excel.

My first combobox has 3 items in it these are the table names

The second combobox i want it to only show values from the matching table 2nd column

1st combobox is called cboWOM and 2nd combobox is called cboOpening

Please Login or Register  to view this content.

I have tried If varients of code too, but just cant seem to get into the table to show the list.

thank you for your help

Try this:

Please Login or Register  to view this content.

Still showing up blank.

I have uploaded the file with your code. See if that helps

Why you set the ColumnWidths property of cboOpening is '0 pt;49.95 pt'? The list is blank because you set first columnwidth is 0. Clear that property and try again.

Ah yeah sorry i did that with earlier versions of code. forgot to change it back

Thanks