Hi, this question may have been asked and answered.
I have a ComboBox on a userform which displays data off an excel spreadsheet, column C and there's corresponding data in column D.
When I make a selection in the ComboBox which is displaying data from column C, I'm looking to display the corresponding data from column D in a TextBox.
So far I've only been able to get the ComboBox and TextBox to match i.e. what I select in the ComBox shows up also in the TextBox.
Any advice?
I have a ComboBox on a userform which displays data off an excel spreadsheet, column C and there's corresponding data in column D.
When I make a selection in the ComboBox which is displaying data from column C, I'm looking to display the corresponding data from column D in a TextBox.
So far I've only been able to get the ComboBox and TextBox to match i.e. what I select in the ComBox shows up also in the TextBox.
Any advice?