Ah should have been Isnumeric

On Nov 26, 5:16*pm, macro rewind wrote:
Tried this but its giving me an error when I run the command button on
the form.

compile error:

Sub or Function not defined

The Debugger than highlights "IsNumber" in grey and Function Check2
with Yellow

Function check2() As Boolean
'check textbox2 has a 9 digit number
If IsNumber