I have searched the faq's and forums an connot find what I need so far. Please point me to an approriate one if you know of it.
In Excel, I have a worksheet with four columns of data. The first column shows data for the first combo box and I have populated this by simply pointing the row source to this data.
I have set up named ranges for the cols of data corresponding to the value selected in the first box.
What I want is for a second combo box to display one of the columns depending on which value is selected in the first one.
I have been trying to pass the value from the first box to a variable and then use this variable as the row source (named range) for the second box.
Can this be done? Any help greatly apreciated. Cheers
In Excel, I have a worksheet with four columns of data. The first column shows data for the first combo box and I have populated this by simply pointing the row source to this data.
I have set up named ranges for the cols of data corresponding to the value selected in the first box.
What I want is for a second combo box to display one of the columns depending on which value is selected in the first one.
I have been trying to pass the value from the first box to a variable and then use this variable as the row source (named range) for the second box.
Can this be done? Any help greatly apreciated. Cheers