Textbox1 | Remove Empty Characters

Hello Again 

Quick question... 

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?

Parents
No Data
Reply Children
No Data