Hi,
i have userform in a module and the userform contains textbox and
commmand box.

If (Not IsNumeric(TextBox1.Value)) Then
response = MsgBox("Please provide acceptable Number", vbOKCancel,
"Wrong value!!!")
If response = vbOK Then
' Load UserForm1
Else
End
End If
End If

Problem:
i want to display the userform1 until numeric value. (kind of pause the
program). Load userform1 or userform1.show are not working for some
reason....

Please help.

musa.biralo