Calling a module 1

[judyscofield]

I'm in the event code of a command button and would like to run a module. What is the syntax to call a module? I can use runcmd.domacro to call a macro, etc., but I'm getting errors calling a module.

Thanks
Judy Scofield

 

[CosmoKramer]

Try the RunCode action.....

 

[MangroBongacello]

Dear Judy

You don't call a module but any function or sub procedure within the module.

If you put a sub procedure you want to call in a general module (modules tab) then you just write a name of that procedure in your event procedure.

Procedure in general module:
Sub ProcedureToBeCalled()
...
...
End Sub

Event procedure:
Sub Command0_Click()
...
...
ProcedureToBeCalled
...
...
End Sub