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?
Just though of this...
Or when I copy my text in the textbox (the textbox "change" ) will auto adjust my text...