check to see if textbox1 value is in column A of sheet 3

[Jenkins27]

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!

[Jenkins27]

this is what I got and its not working

Please Login or Register  to view this content.

[Jenkins27]

I also tried

Please Login or Register  to view this content.

[stnkynts]

There are a couple of types of Textboxes. Since you did not specify I will assume you are using a UserForm Textbox called TextBox1.

Please Login or Register  to view this content.

[mikerickson]

You set a worksheet variable, but don't use it to qualify your range.

Please Login or Register  to view this content.

[Jenkins27]

alright I got part of it to work but the part in the red is not working... any ideas?... what im trying to do in that part is see if textbox1 value is already in column A of sheet3 and if if it is a message to pop up...

Please Login or Register  to view this content.

[Jenkins27]

ive also tried this

Please Login or Register  to view this content.

[Jenkins27]

Im not sure how to get this to work.. Anyone git any ideas?

[Jenkins27]

is there a better way to code this so it will work

[mikerickson]

Did you try the line from post #5?

If that doesn't work, could you attach a workbook that shows the problem.

[stnkynts]

Is your worksheet called Sheet3 or "all parts". You have declared it twice. If you don't have a Sheet3, remove that line or else it won't work. Also, posting multiple posts when you don't get a response will not help you case.