populating one list/combobox based on the results of another
Hi,
I'd be grateful if someone could help with what i think is probably quite a
simple thing (just not as simple as me).
I have a userform with two comboboxes; the data for these come from one
data-table. combobox1 is filled with the table heading data (ie, from a
single row) and this works fine; what i can't do is populate the the second
combobox with the column of data in the data-table below the relevant header
(as chosen in the first combobox). i want the population to be programmatic
/ dynamic as the table is likely to change over time.
hope someone can help, cheers,
tim
|