If Statement With Wildcard Not Working Follow
Hi, I have entered the below IF statement to make a textbox display a value based on a field.
If the field starts with GB the box should display Made in GB, if CZ Made in CZ, anything else Error.
However it doesn't work and I can't find any proper information on what wildcard to use for numbers only.
If I enter a whole serial number it works fine.
If Format.NamedSubStrings("Serial").Value ="GB********" Then value = "Made in GB" Elseif Format.NamedSubStrings("Serial").Value ="CZ********" Then value = "Made in CZ" Else value = "Serial error" End If
Any ideas? Thank you for reading.
Please sign in to leave a comment.