Hi

i've created a user form (frmInfoLog) im trying to find the right code to get excel to search cell B4 for the value i type in the first text box of my form (txttops). when it finds the correct value i want it to insert the remaing information from the form into the adjanct cells.

I ive got this code so far, but im having trouble writing the code to get the macro the search for the vaule in txtops.

Private Sub cmdupdate_Click()

ActiveWorkbook.Sheets("Info log 2005").Activate

Range("B4").Select

Do

If IsEmpty(ActiveCell) = False Then

ActiveCell.Offset(1, 0).Select

End If

Loop Until IsEmpty(ActiveCell) = True

ActiveCell.Offset(0, 11) = txtops.Value

ActiveCell.Offset(0, 12) = txtsurv.Value

ActiveCell.Offset(0, 13) = txtdate3.Value

ActiveCell.Offset(0, 14) = txttime3.Value

ActiveCell.Offset(0, 15) = txtteam.Value

Range("B4").Select

End Sub

Can anyone help, thanks