Can I set up a loop using Do Until the else statement is hit? I want the second If statement to loop until someone is done adding additional signers, once they click cancel it should exit the loop. The problem is the only thing happening in the Else is a carriage return, which happens in the normal statement as well. I guess I could add an erroneous statement for it to trigger off of if there is no other option.
Code:If InStr(Reflection.gettext(0, 0, 23, 80), "Additional alert recipients:") > 0 Then If Forms!frmTestForm.Form!AddAlert = True Then AlertName = InputBox("Please enter a name for the alert. Format Lastname,FirstName") .transmit AlertName .transmit Chr(13) Pause (0.45) Do Until Else If InStr(Reflection.gettext(0, 0, 6, 80), "And Additional alert recipients:") > 0 Then AlertName = InputBox("Please enter an additional name for the alert. Click cancel if no additional alerts required.") .transmit AlertName .transmit Chr(13) End If Else .transmit Chr(13) End If End If


Do until Else
Reply With Quote
