Using a userform to amend a string of VBA Script

Hey All,

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

Please Login or Register  to view this content.

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?

You don't even need a userform/textbox. It can be done simply by using an InputBox. Code such as the following should work:

Please Login or Register  to view this content.

Legend! - Sometimes things are just so simple! - Thanks very much BigBas. Added rep.

Thanks Steven.

I'm glad I could help you out.