call procedure from another module

  • Thread starter Thread starter John Thomas
  • Start date Start date
J

John Thomas

How do I run a procedure in my current module, which is located in another
module, The module name that I want run is Form1, in the window caption it
reads, Form_Form1:Class module. And I wan to call the procedure, Private Sub
Form_Load() in that Form1 module from another module?

Thanks John
 
You have to make the procedure public instead of private
in order to call it from another module.
Steve
 
I've changed it to a Public sub, how do you call it, I'm trying to do it the
following code, but it can't find it.
'Forms!Form1!.Form.Form_Load

Thanks
 
Try this:

Call Form_Form1.Form_Load
-----Original Message-----
I've changed it to a Public sub, how do you call it, I'm trying to do it the
following code, but it can't find it.
'Forms!Form1!.Form.Form_Load

Thanks



.
Click to expand...
 
Back
Top