I have tried by using On error Go, just to handle error and showmy MsgBox then turn the value inputed to default value. I will try on errorresume.