listboxes linked to each other

[gkisacik]

Hello there,

I have here userform with 2 listboxes.

I would like to have the situation that when the user click on a value in listbox2, then the row source on the listbox1 should change. (The row sources are on different tabs).

To make it clear; the values are listed on listbox2 are Trial 1, Trial 2 , Trial 3.... (same as the sheet tabs).
When i click on Trial 1 on the listbox2, the listbox1 should show the values from sheet tab "Trial 1". Probably change of rowsource.

any suggestions?

Thanks in advance

gkisacik

[MickG]

Hi, If you name your ranges in each sheet then you can use this.
NB:- if your using a "Useform" Change for "ListFillRange" for "Rowsource.

Please Login or Register  to view this content.

Regards Mick

[Palmetto]

Adjust sheet reference and ranges as required.

Please Login or Register  to view this content.

[royUK]

I have an example here

LinkedListBox.zip