I have a textbox and I want to be able to search for data in a workbook (that
is entered in the textBox) and when data is found paste the entire row into
sheet 1 of the workbook. Any help on this would be greatly appreciated.
Thanks
-mark
Sample Code that does not work for me:
Private Sub cmdFind_Click()
Dim R As Range
On Error Resume Next
Dim Sheet As Worksheet
With Worksheets("Sheet2").Range("")
Set R = Range("activesheet").Find(What:=txtFind.Text, _
LookAt:=xlWhole)
If R Is Nothing Then
MsgBox "Bummer"
Else
R.Copy Destination:=Worksheets("Sheet1").Range("E5")
End If
End With
End Sub