View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] akh2103@gmail.com is offline
external usenet poster
 
Posts: 28
Default How to elegantly end a main procedure from a userform command button?

Hello--I am looking for a tidy way to end a main procedure from a
userform command button. One idea that might work (say the newsgroups)
is to to run a boolean function procedure that returns a value, False
if certain conditions are met. Then one could check for a false value
in the main procedure before continuing. However, I am having trouble
connecting userform buttons with function rather than sub procedures. I
am sure that this is a common problem. Can anyone suggest an elegant
way out? Thanks. -Abe