Found a way but it only works if the number is 5 numbers long like 12345
Code:
Dim strNumber As String
strNumber = Strings.Right(Text1.Text, 5)
Text1.Text = strNumber
This will take the last 5 digits from the URL you put in text1.text then put the 5 digits into text1.text when you click a button,
i sopose the only other way would be to have some option boxes so the user would have to tell you how many numbers are at the end and do something likes
Code:
if opt5.value = true then
strNumber = Strings.Right(Text1.Text, 5)
Elseif opt6.value = true then
strNumber = Strings.Right(Text1.Text, 6)
End if
Hope this helps