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.

mark kubicki wrote:

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

--

Dave Peterson