exit sub when textbox contains certain item

[kelly mort]

Hi all
I have a textbox called Reg1 on a userform and i want to exit sub when certain numbers or unique IDs are in it and i still click the back button. The numbers are started with texts like wkx1001 , wkx2001, wkx3001 up to wkx52001.

Adding 52 if statements is too long i think. So i have decided to post it here for a simpler approach.
Thanks in advance for reading and willing to help

 

[kelly mort]

So when any of the above IDs is in the Reg1, just exit sub because they start the list.

 

[kelly mort]

Still counting on you

 

[kelly mort]

Still need help please

 

[dmt32]

Hi,
if saying there are a range of numbers (IDs) that you want your code to exit if any displayed?
If so, you could get your code to check e.g.

 If Val(Reg1.Value) > 1000 And Val(Reg1.Value) < 5200 Then Exit Sub

or you could create a table with all excluded numbers where you code can make the check.

Would be more helpful if you published the code you want to amend.


Dave

 

[kelly mort]

Hi,
if saying there are a range of numbers (IDs) that you want your code to exit if any displayed?
If so, you could get your code to check e.g.

 If Val(Reg1.Value) > 1000 And Val(Reg1.Value) < 5200 Then Exit Sub

or you could create a table with all excluded numbers where you code can make the check.

Would be more helpful if you published the code you want to amend.


Dave

I used this code when i had only one sheet named week1.

If Me.Reg1.Value = "wkx1001" Then Exit Sub

 

[dmt32]

You can strip the text out to evaluate the number using Mid function

If Val(Mid(Reg1.Value, 4)) > 1000 And Val(Mid(Reg1.Value, 4)) < 5200 Then Exit Sub

does this help?

Dave

 

[kelly mort]

Hi,
if saying there are a range of numbers (IDs) that you want your code to exit if any displayed?
If so, you could get your code to check e.g.

 If Val(Reg1.Value) > 1000 And Val(Reg1.Value) < 5200 Then Exit Sub

or you could create a table with all excluded numbers where you code can make the check.

Would be more helpful if you published the code you want to amend.


Dave

No it did not work. I think what you have here is a rang of nimbers. I want only the numbers i showed above to be exited

 

[JLGWhiz]

How about, assuming your code is installed in the parent object to the textbox.

If Me.Reg1.Value Like "wkx*" Then Exit Sub

 

[kelly mort]

Hi,
if saying there are a range of numbers (IDs) that you want your code to exit if any displayed?
If so, you could get your code to check e.g.

 If Val(Reg1.Value) > 1000 And Val(Reg1.Value) < 5200 Then Exit Sub

or you could create a table with all excluded numbers where you code can make the check.

Would be more helpful if you published the code you want to amend.


Dave

How about, assuming your code is installed in the parent object to the textbox.

If Me.Reg1.Value Like "wkx*" Then Exit Sub

This does not move it at all