Link combo box selection to a cell
 

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

Link combo box selection to a cell
 

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


"Sara" wrote:

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