Consolidate Macros

  • Thread starter Thread starter acss
  • Start date Start date
A

acss

I have about 8 macros for the purpose of functions tied to the switchboard
such as opening forms ,queries etc. Is there a way to consolidate all these
macros into one module?
 
Do you mean you want to convert the Macros to VBA and put them all in one
standard module?

If so, convert the Macros. They will each produce their own module.
Create a new module. Copy/Paste the code from each of the conversion
generated modules into your new module. Be sure none of the functions or
subs have the same name. Give your module a name that is different from any
procedure in the module.
 
That is exactly what i need to do since i can see that having many macros is
not very organized. Once all are consolidated into one module then i would
need to refer the actions in the switchboard to this new module.Is this
correct?
 
If you want to execute VBA code from a Switchboard, be sure each procedure is
a Function. You can use the RunCode action in a switchboard, but it has to
be a function.

I think at some point in time; however, you will begin to be frustrated with
the limitations of a switchboard and write your own forms where you have more
control over what you are doing.
 
Back
Top