I know this must be simple, but I have spent the morning searching posts and trying on my own...
I have cell D10 with data validation that allows the user to pick from "A, B, or C."
If they select "A," I want "list A" to appear in either cell E10 or a combo box, "B" and "list B" etc.
Here's what I was using for the combo box code...
Private Sub ComboBox1_Change()
If Range("D10").Text = "A" Then
ComboBox1 = Range("List A").Text
Else
If Range("D10").Text = "B" Then
ComboBox1 = Range("List B").Text
Else
If Range("D10").Text = "C" Then
ComboBox1 = Range("List C").Text
End If
End If
End If
End Sub
Would it be easier to code in the cell?
Thanks for any help you can provide!
I have cell D10 with data validation that allows the user to pick from "A, B, or C."
If they select "A," I want "list A" to appear in either cell E10 or a combo box, "B" and "list B" etc.
Here's what I was using for the combo box code...
Private Sub ComboBox1_Change()
If Range("D10").Text = "A" Then
ComboBox1 = Range("List A").Text
Else
If Range("D10").Text = "B" Then
ComboBox1 = Range("List B").Text
Else
If Range("D10").Text = "C" Then
ComboBox1 = Range("List C").Text
End If
End If
End If
End Sub
Would it be easier to code in the cell?
Thanks for any help you can provide!