Need to search a string for numbers
Hi all! What I am trying to do sounds like it should be easy, but it is not
working for me...Here is what I am trying to do...
User pushes a button that brings up an input box, the value typed in that is
saved as 'ColumnBox'. I then Want to check ColumnBox to see if it has numbers
in it, if it does, I want to produce an error (which I can do the error part
fine), or if there is no number than continue the procedure.
Any ideas? Ive been trying combonations of InStr and Isnumeric, but nothing
works 100%
|