Hi - I've tried several different things that would
be logical in a spreadhsheet to ensure that the
entry into a Textbox is a number such as:

If WorksheetFunction.IsError(Clng(Textbox1.Value)) Then

But it dies on the Type mismatch.
Is there some way to trap the entry that I'm not thinking of?