Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input box with a loop
I have an input box that pops up and asks a question. If the user enters the
correct answer, a message box will show saying that's correct, and after clicking ok move on to the next question. Right now, when the user enters the wrong answer, a message box saying that's incorrect shows, but then it moves on to the next question when ok is clicked. Is there a way to do a loop so that when the incorrect answer is selected, the original question reappears instead of going to the next question? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input box with a loop
Hi,
A look at your code would have been helpful but here's one way Sub liminal() retry: response = InputBox("What is the meaning of Life?") If response < 42 Then response1 = MsgBox("Now that's incorrect, please re-read the book", vbRetryCancel) If response1 = vbRetry Then GoTo retry Else MsgBox "Well done, the meaning of life is " & response End If End Sub Mike "aimee209" wrote: I have an input box that pops up and asks a question. If the user enters the correct answer, a message box will show saying that's correct, and after clicking ok move on to the next question. Right now, when the user enters the wrong answer, a message box saying that's incorrect shows, but then it moves on to the next question when ok is clicked. Is there a way to do a loop so that when the incorrect answer is selected, the original question reappears instead of going to the next question? Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input box with a loop
And with a loop
Sub versives_R_us() Do response = InputBox("What is the meaning of Life?") If response < 42 Then response1 = MsgBox("Now that's incorrect, please re-read the book", vbRetryCancel) Else MsgBox "Well done, the meaning of life is " & response End If Loop Until response = 42 Or response1 = vbCancel End Sub Mike "aimee209" wrote: I have an input box that pops up and asks a question. If the user enters the correct answer, a message box will show saying that's correct, and after clicking ok move on to the next question. Right now, when the user enters the wrong answer, a message box saying that's incorrect shows, but then it moves on to the next question when ok is clicked. Is there a way to do a loop so that when the incorrect answer is selected, the original question reappears instead of going to the next question? Thanks! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input box with a loop
Thanks! I tried the first response with the goto retry and that seems to be
working! "aimee209" wrote: I have an input box that pops up and asks a question. If the user enters the correct answer, a message box will show saying that's correct, and after clicking ok move on to the next question. Right now, when the user enters the wrong answer, a message box saying that's incorrect shows, but then it moves on to the next question when ok is clicked. Is there a way to do a loop so that when the incorrect answer is selected, the original question reappears instead of going to the next question? Thanks! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input box with a loop
Your welcome and thanks for the feed back.
"aimee209" wrote: Thanks! I tried the first response with the goto retry and that seems to be working! "aimee209" wrote: I have an input box that pops up and asks a question. If the user enters the correct answer, a message box will show saying that's correct, and after clicking ok move on to the next question. Right now, when the user enters the wrong answer, a message box saying that's incorrect shows, but then it moves on to the next question when ok is clicked. Is there a way to do a loop so that when the incorrect answer is selected, the original question reappears instead of going to the next question? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop to Filter, Name Sheets. If Blank, Exit Loop | Excel Programming | |||
endless loop - using input box | Excel Programming | |||
Loop through a range, allow user input during... | Excel Programming | |||
Collecting textbox input within a for loop | Excel Programming | |||
Loop through for condition and input in adjacent cell | Excel Programming |