I have a text box i'm using to find stuff ... Basically put in my word and click a command button to find it. But I'm having to manually remove empty characters before or after my text (mostly only after i copy and paste my phrase in the textbox) to search. How do I set my vba code up to recognize there is a space before and/or after my text and remove it?
Example: ( _ = space)
Find word "Apple"
But when i copy & past "Apple" in my Textbox there will be a space before or after "Apple" and the results cannot be found. "_Apple", "Apple_" or "_Apple_"
So how do I remove empty characters upon clicking my command button?
Look up the VBA string functions. There are a bunch of them.
LTrim, RTrim, and Trim might be of particular interest to you.