Re: combobox to textbox to combobox
I beleive I got about half of it worked out with
Code
Sub UpdateCombobox1()
If Me.ComboBox1.Value = Range("firstname")(txtRow.Text).Value Then
Me.ComboBox1.RowSource = "firstname"
End If
End Sub
This sets the combobox to the txtrow value and then allows me to view the range set for the box.
So now what I need to do is set the txtRow box to compare to combo box
If the value of the combobox changes the txtRow needs to. I tried this
Code
Sub UpdatetxtRow()
If txtRow.Value <> ComboBox1.Value Then
txtRow.Value = ComboBox1.Value
End If
End Sub
it doesnt work.