Displaying data from value of text box

[TheMatrixReloaded]

The phone number text box and address text box are on the same form. The address needs to be displayed as soon as the phone number is entered. If the value of my phone number in the text box, equals a phone number in another sheet (Phone Table), then the address should display in the address text box below the phone number text box.

 

[Mark O'Brien]

Something like this (note: I've not tested this and I'm just typing this into the forum, so if it works first time, that's amazing) I've also called your textboxes - txtPhone and txtAddress respectively and I've assume that the Phone number is in the column to the right of the address. i.e. if Phone number is in Column A, Address is in Column B:

<pre>
Dim oRange As Range

Set oRange = Sheets("Phone Table").UsedRange.Find(What:=txtPhone.Text)

If Not oRange is Nothing then
txtAddress.Text = oRange.Offset(1,0).Value
End if</pre>

Put this code on a button click event or something.

If you need any help just repost.

HTH