prevent symbols from the textbox using Exist event.

[SamarthSalunkhe]

I'm using the below change event to prevent symbols from the textbox. I have tried to use it under Exit but it's not working.
can someone help me to validate this under the Exit event?

Private Sub TxtName_Change()

Dim LastPosition As Long

Const PatternFilter As String = "*[!0-9A-Za-z ]*"

Static LastText As String
Static SecondTime As Boolean
If Not SecondTime Then
With txtName
If .Text Like PatternFilter Then
MsgBox "Special Character is not allowed in this tab", vbExclamation, "Special Character Found"
SecondTime = True
.Text = LastText
.SelStart = LastPosition
Else
LastText = .Text
End If
End With
End If
SecondTime = False
 
End Sub

 

[abdelfattah]

it works for me . just make sure the name textbox in exit
event .may be not matched with name of textbox

 

[SamarthSalunkhe]

it works for me . just make sure the name textbox in exit
event .may be not matched with name of textbox

Could you please provide which changes you have done code, might be I am missing something?

 

[abdelfattah]

sorry ! I was too busy . based on your code just see the picture mark by blue . should be the same name and I expect your userform contains more than one textbox to exit and move to the next textbox to show the code how works
I hope this help

 

[SamarthSalunkhe]

sorry ! I was too busy . based on your code just see the picture mark by blue . should be the same name and I expect your userform contains more than one textbox to exit and move to the next textbox to show the code how works
I hope this help
View attachment 53256

Thank you for your support, It working fine.

do you have any idea to make this code simple like the below code, as it is difficult to understand?

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)

With TextBox1
    If .Value <> "" Then
        If Not .Value Like "[A-Z][A-Z][A-Z][A-Z]0[A-Z0-9][A-Z0-9][A-Z0-9][A-Z0-9][A-Z0-9][A-Z0-9]" Then
             MsgBox "Wrong input", vbExclamation, "Incorrect Number"
            Cancel = True

        End If
    End If
End With


End Sub

 

[abdelfattah]

sorry buddy ! I wish to help you but I can't . actually I'm too beginner in vba like you. and I try learning from the experts in this great forum .

can you tell me what you want to do? . may be I've found some idea from the nternet or experts help you if you give the exactly your requierement.

 

[SamarthSalunkhe]

sorry buddy ! I wish to help you but I can't . actually I'm too beginner in vba like you. and I try learning from the experts in this great forum .

can you tell me what you want to do? . may be I've found some idea from the nternet or experts help you if you give the exactly your requierement.

Thank you, actually, the code is fulfilling my requirement, just want to make it simpler so that I can understand the commands I have used.

 

[abdelfattah]

but why don't ask so from code owner . I think this code for @Akuini