Link combo box selection to a cell

S

Sara

I have made several dropdown lists with combo boxes and in each of them I
have a choice called "other". I would like to have this selection lead the
user to a cell lets say B1 and list what is other in that cell. I am not sure
how to make this work. Any help would be great.

Thanks
 
F

FSt1

hi
is i understand you, this might work for you....
Private Sub ComboBox1_Change()
If ComboBox1.Value = "other" Then
Range("B2").Select
End If
End Sub

regards
FSt1
 
Top