Event Procedures

  • Thread starter Thread starter alicia
  • Start date Start date
A

alicia

I have two macros I want to carry out "OnClick".
I know how to type in just one macro, but how about 2? I
have tried ';' '&' but neither of these carry out the
second macro.
Cheers
 
Alicia,
Macros?
You can run only one macro name from the property sheet's event line,
however each macro name can have many macros. Just open a macro sheet in
design view and place the next one on a line beneath the first macro. Rename
the macro sheet. Place the name of the sheet on the event line. All the
macros on the sheet will run.
Here is an example.
The macro sheet is named 'BeginMonth'.
On the sheet are several macros.
MsgBox
SetWarnings
RunQuery
SetWarnings
SetValue


BeginMonth would be written on the property sheet's event line.

Additionally, you can run any individual macro on that sheet by using the
following syntax:
MacroSheetName.IndividualMacroName

Why not use code instead?
It has the advantage of allowing error handling and is easier to make
changes.
 
Back
Top