string validation help needed

[dantheman9]

Hi Im trying to validate if a text string is in a set format,but can't work out how to do it!
format should be a "0** - *" format, with three number values at the start and then text after the -.

If Not TextBox1.Value = Format(TextBox1, "### -" & TextBox1) Then

 

[Ralajer]

Try the Like operator.

If Not TextBox1.Value Like "### - ?*" Then

 

[Rick Rothstein]

Hi Im trying to validate if a text string is in a set format,but can't work out how to do it!
format should be a "0** - *" format, with three number values at the start and then text after the -.

If Not TextBox1.Value = Format(TextBox1, "### -" & TextBox1) Then

Your description is not clear to me at all. You say you want 3 digits but showed a leading 0 first. You also make references to "text after the -" which is unclear to me as well. Can you post some sample text strings that would pass your validation criteria? Also, show some that would not pass and explain why.