verifing entry is numeric

  • Thread starter Thread starter mark kubicki
  • Start date Start date
M

mark kubicki

is there a quick way (in VBA) to assure that the user has entered (into a
predetermined rangeon a worksheet) a numeric.

i can easily setup a formula to montor changes in the range, but don't know
how to check if the entry is numeric, and, if it is not, reject it ...
 
if isnumeric(activesheet.range("a1").value)) then

Will be true for empty cells, '1234 (numbers as text).

if application.isnumber(activesheet.range("a1").value)) then

Is the worksheet function--which is more stringent.
 
Back
Top