View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
musa.biralo musa.biralo is offline
external usenet poster
 
Posts: 55
Default show userform when response = yes

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 userfom1 until numeric value in textbox. After
clicking yes, userform is not showing up. (this code runs when command
button of userform is clicked)

load userfor1 or userform1.show are not working for some reason..
commandbutton1_clik gives infinite loop when placed at true condition
of response.

Please help

musa.biralo