Emoncada
12-06-2007, 10:51 AM
I have something like this
res = InputBox("Please Enter Password")
If res = "candy" Then
It will run a couple of formulas.
I would like so if res doesn't = "candy" then to prompt res2 = MsgBox(""Sorry wrong Answer! Please Try Again!", vbYesNo)
And if clicked Yes loop back to the original res InputBox.
If clicked No To Exit Sub.
Any help would be great. Thanks
res = InputBox("Please Enter Password")
If res = "candy" Then
It will run a couple of formulas.
I would like so if res doesn't = "candy" then to prompt res2 = MsgBox(""Sorry wrong Answer! Please Try Again!", vbYesNo)
And if clicked Yes loop back to the original res InputBox.
If clicked No To Exit Sub.
Any help would be great. Thanks