View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
havocdragon havocdragon is offline
external usenet poster
 
Posts: 75
Default 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%