Hey All,

I have the following extract from a vba sub in my worksheet;

  
Set c = .Find("Agent Name:*", icell, xlValues, xlWhole, , xlNext)
    
    If Not c Is Nothing Then
        
        firstaddress = c.Address
        
        Do

c.EntireRow.Select
Selection.Copy
Basically what I want to do is have a userform textbox to amend the string "Agent Name:*" so that the sheet can be manipulated to find any given value by the user.

Can this be done?