Looping
 

MyUnit = InputBox("Unit")
If MyUnit Like "ACLG*" Then
MsgBox ("Large Bal")
ElseIf MyUnit Like "A*" Then
MsgBox ("Attorney")
End If

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"StephanieH" wrote in message
...
How can I set up a loop to evaluate data but end when it evaluates to
true?
For example, if MyUnit is "ACLG3" I only want the "Large Bal" message to
pop
up. I do not want it to go on to evaluate the second line of code. As it
is
currently written "ACLG3" will trigger both messages since the code sees
them
both.

MyUnit = InputBox("Unit")
If MyUnit Like "ACLG*" Then MsgBox ("Large Bal")
If MyUnit Like "A*" Then MsgBox ("Attorney")