Finding a function to close a process

[George]

Good Day All,

I am using the 'Exit Sub' command in a procedure to close the procedure. However that procedure closes but the procedure that called this procedure continues to function. I want a function that would close all the procedures and allow me to restart from the button command.



would be grateful for some help.

[CJ_London]

so you need something in the calling procedure to exit the sub - perhaps your called procedure should act5ually be a function that can return a value that the calling procedure can interprete and exit itself e.g.

function calledFunction() as Boolean

   if 1=2 then 'continue
       ...
       ...
   else
       calledfunction=false
       exit function
   end if

end function

sub calling procedure

    if calledfunction=false then exit sub

end sub

[George]

Thanks. The function suggestion is a good idea. I have employed it and that's just fine.