Would you like to tell us a little bit about your user form?  Like, are you
using labels, textboxes, list boxes or comboboxes to display the data that
you call from your worksheet.  And how about the layout of the worksheet?  Is
it designed so that the individual data elements that you intend to retrieve
can be easily accessed?
I have a program where I retrieve about ten data elements.  I have them
arranged in columns so that all elements for a single call are on one row.  
That allows me to not only locate them easily, but to also select them
individually for corrections.  You can call them up by using the Find method,
in your case it would be by ID#.  Then use Offset to access the individual
columns of data.  To put the data in the form, if you use labels, Label1 =
ID#.Offset(0, 2).  If you have five elements to populate you can use a loop
with a variable to get all five in one search.  

For i = 1 To 5
  Label & i = ID#.Offset(0, i)
Next

Maybe this will get you started.

Syntax correction.

Label1.Caption = ID#.Offset(0, 2).Value

Albert,

Put a commandbutton on your userform, with code like

Private Sub CommandButton1_Click()
Dim myC As Range
Set myC = Worksheets("Sheet1").Range("A:A").Find(UserForm1.TextBox1.Text)
If myC Is Nothing Then
   Msgbox UserForm1.TextBox1.Text & " was not found."
Else
   Userform1.TextBox2.Text  = myC(1,2).Value 'Pick up the cell to the right of the ID#
   Userform1.TextBox3.Text  = myC(1,3).Value 'Pick up the cell two to the right of the ID#
End If
End Sub

You cannot have a textbox named "Customer ID" since that is an illegal name....

HTH,
Bernie
MS Excel MVP