It is possible to avoid 'compile Error' when calling another macro and
that macro doesn't exists, by using Application.Run.

So, instead of using

Call TheOtherMacro

....you use:

Application.Run "TheOtherMacro"

That way the original macro will still compile, even if 'TheOtherMacro'
doesn't exists (yet).


Is it possible to do something similar with UserForms???

If I use:

UserForm1.Show

....and the userForm doesn't exists yet, the code will error during
compile time, but I need my UserForm to be created during macro run, so
is it possible to avoind compile error, if a UserForm doesn't exists
yet, just as if a macro doesn't exists at compile time???


Thanks,

CE