use value in texbox to search through worksheet
 

Hello, I'm still new at this and learning.
I have created a form and textbox, lable and a command button.
I want to make it where when you enter a value in the textbox, and click the
command button, it will open up a worksheet then look at column "A" and see
if the value exist. If true then lable will say "yes", else "no".

Please help!
Thank you!