calling a macro using if statement?

[aspiringnerd]

some weird stuff is happening when I combine a bunch of macros together but work fine if I run them seperately. Rather than calling them the traditional way, is it possible to use an if statement to trigger another code automatically?

sub autotrigger()
if codeA = TRUE then
calls code B
else

endif


end sub

I've tried putting a delay in my code, but it doesnt work. I'm just trying to have a function execute once the first function completely executes.

 

[Micron]

Technically, you cannot without having separate calls or events that trigger subsequent code to execute. IF the last line in a procedure calls another procedure, that's as close as you can get. When the 2nd, 3rd... last procedure in the stack executes End Sub or End Function, control is given to the last in the stack. Rinse and repeat.

You could make the calls to functions that return values and make what happens next contingent upon the returned value if that helps, but methinks it's not what you're trying to do.