When I click on the cancel button within the inputbox it gets stuck in the loop. How can I exit sub when cancel is clicked. Thank you.
Sub splitLot()
answ = ""
ans = MsgBox("Is this a split lot?", vbYesNo + vbDefaultButton1, "Split Lot")
If ans = vbNo Then...