Hi,
I have a code which works fine in respect of looking up a customers name, showing me the options in the display box & once i click the name i am taken to that person who is then in column B
This is the code.
Private Sub TextBox1_Change()
Dim r As Range, f As Range, Cell As String...