Num = InputBox("Enter a number ")
If Num = "" Or Not IsNumeric(Num) Then
MsgBox "you have cancelled or not entered a valid number"
End If


Gord Dibben MS Excel MVP

On Mon, 15 Sep 2008 11:54:01 -0700, Jase
wrote:

I am using an input box, when i select the cancel button on my input box it
gives me a debug. Do I need to code this button to cancel? if so how?

thanks,

Jase