Good morning

I have ComboBox1 (Stock Market) and ComboBox2 (Stock name), and I want the list in my ComboBox2 to be dependent on ComboBox1.
(i.e. I want ComboBox2 to show only stocks that are in the stock market chosen in Combobox1)


If my helping columns are in the same worksheet, my colleague told me to use the following code:

Please Login or Register  to view this content.
However, when they are in different worksheets, it doesn't seem to work.

Thank you very much in advance!