verifing entry is numeric

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 ...
 
D

Dave Peterson

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.
 
Top