Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart to show response to a question. One of answer 15 choices. | Charts and Charting in Excel | |||
How do I transform a word response to a numeric response? | Excel Discussion (Misc queries) | |||
How do I set up a daily call out response response register? | Excel Worksheet Functions | |||
show userform when response = yes | Excel Programming | |||
Program a drop down list to show a specific response depending on the selction | Excel Programming |