I want it so when commandbutton2 is pressed it checks to see if the value of textbox 1 is in column A of sheet 3... if it is continue with code if not message that says "Please correct"... thank you!