"JLGWhiz" wrote in message
...
Forgot to paste:

If UserForm1.ComboBox1.Value = Joe Then
MyVariable = ActiveSheet.Range("A2:A100").Find _
("Joe", LookIn:=xlValues).Offset(0, 1).Value
End If

But won't I have to rewrite the code every time I change any of the
thousands items in column A?