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
Bookmarks