Validating the first letter with Vba Left function in a Textbox not giving desired result

Good day,
Hope you are well.

I am trying to validate the first letter with the Left function in a Textbox1, whether an user has added a "S" or an "A" in front of the value in a Textbox, before allowing submitting of the Textbox value. The problem is my validation code is not picking up whether there is a "S" or "A".

I am not getting any errors, the Left function is not picking up whether there is or is'nt a "S" or "A" as the first letter.

My code:

Please Login or Register  to view this content.

What I have tried to solve the issue:
1] I have checked whether any Library References is missing. "There where none missing."
2] I have tried different iterations of the Left function e.g. Application.WorksheetFunction.Left (does give an error), Left and VBA.Strings.Left
3] I have referenced to Value rather than Text in the Textbox1 e.g. Textbox1.Value
4] I have validated the boolean If iteration as If Not True or Not True rather than If False or False e.g.

Please Login or Register  to view this content.

Can someone please point me in the right direction or give advice on why the Left function is not functioning as it should?

Regards,

The problem is your logic.

It appears that you want your code to execute if the first letter is neither S nor A. That is not what your logic says. However, this error should cause your code to always run, and you are saying it never runs.

Let's boil down you logic first.

If Strings.Left(Textbox1.Text, 1) <> "S" Or Strings.Left(Textbox1.Text, 1) <> "A" Then

If the first letter is S then your code will do this:

If "S" <> "S" Or "S" <> "A" Then

which evaluates to

If False Or True Then

which evaluates to

If True Then

Your If condition will always be True, no matter what the first letter is.

Second, I have never seen nor used String before. I just use Left. Try this and report back.

Please Login or Register  to view this content.

If this does not work then you have some other problem that is not related to the code you showed us here. Please attach your file and describe the steps you take for this code to run.

You did not indicate what kind of textbox.
I assume it is a textbox in a userform since you were using labels.

If you use the TextBox1.exit event, this will ensure the entry right away.

Please Login or Register  to view this content.

Hello Jeff,
You are correct, the problem was my logic. I forgot that a True And False = False.
My code for completeness:

Please Login or Register  to view this content.

Thank you very much for your quick logic and answer.

I will mark this question as Solved.

Regards,