View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
teepee[_3_] teepee[_3_] is offline
external usenet poster
 
Posts: 107
Default Stopping a userform subroutine

I have a looping sub triggered by a userform button. I'm trying to figure
out how to stop that same sub with another button on the same userform. It's
kind of ugly just hitting escape. Any ideas? Is there a standard way? I
tried 'loop until' and making the second button achieve the 'until'
condition but that didn't work - I can't trigger the second button at all.