Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart to show response to a question. One of answer 15 choices. PirateSam Charts and Charting in Excel 2 November 9th 09 02:13 PM
How do I transform a word response to a numeric response? kanegaro Excel Discussion (Misc queries) 0 January 11th 08 05:08 PM
How do I set up a daily call out response response register? Pule Excel Worksheet Functions 1 October 7th 07 01:34 PM
show userform when response = yes musa.biralo Excel Programming 2 September 17th 06 07:31 PM
Program a drop down list to show a specific response depending on the selction Vita Cator Excel Programming 1 October 30th 03 07:12 PM


All times are GMT +1. The time now is 10:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"