Check if the last part of entered string is an Integer

[szpt9m]

Hi All,

I have a macro with a Textbox and a button.

in that macro user is allowed write any values. But I need to put a restriction that user must enter only alpha numeric value and also the last part should be numeric.

Like if the user enters TEST_100 then it is correct.. but if the user enters 100_TEST then it show an error message..

So only last part of the string should be numeric..

can anyone help me?

Thanks.

[venkatpvc]

try this

Private Sub CommandButton1_Click()
    With CreateObject("vbscript.regexp")
        .Global = True
        .Pattern = "[A-Z]+\_[0-9]+"
    If .test(TextBox1.Value) Then
        MsgBox "Correct Entry"
    Else
        MsgBox "Wrong Entry"
    End If
    End With
End Sub

[szpt9m]

Thanks Venkat.. working as expected..

[venkatpvc]

glad i could help, and thank you for the feedback.

[szpt9m]

Hi Venkat,..

Could you help me to change few things in the above regex?

liek I have changed it as below

 With CreateObject("vbscript.regexp")
        .Global = True
        .Pattern = "[A-Za-z]+\_[0-9]+"
    If .test(TextBox2.Value) Then

so now I am able to use both caps and small letters in the first field..

Example: Test_100 and TEST_100, test_100 holds good..

I want to have another logic which should allow users to enter test100 or TEST100 or Test100.. What I mean to say that, it should allow only _ in the text box but that should not mandatory... and no other special characters are allowed which is now working fine.. Pls Help..

Thanks.

[venkatpvc]

Private Sub CommandButton1_Click()
    With CreateObject("vbscript.regexp")
        .Global = True
        .Pattern = "[A-z]+\_?[0-9]+"
    If .test(TextBox1.Value) Then
        MsgBox "Correct Entry"
    Else
        MsgBox "Wrong Entry: You are Only Allowed to Entry as Examples: TEST_100, test_100, TEST100, test100, Test100"
    End If
    End With
End Sub

[szpt9m]

Hi Venkat..

it is allowing other special characters as well.. like if i use test\_test100 it allows.. but i want it to allow only _ and which should not be mandatory..

Thanks