It seems that even if a Sub is declared public in the code for a form it is not possiblne to call it from outside the form-code screen.
Is this true?

As an alternative is there any kind of method to effect an event on a form like a method to emulate a button having been clicked via vba?

I can't easily moving the target sub out of the form code to a module (where public means something), but there is a 3rd party activex which must resides on a form so we are stuck with the form.

Any hints will be appreciated.

__________________
Tim

Hi rahzan,

You can call the Sub (treating it like a method of the form class) if you first reference the form via an object variable. The following uses a form named Form1:

In the form class:

Public Sub MyMethod()
    MsgBox "Test"
End Sub

In a standard module:

Sub TestSub()

    ' Declare an object variable
    Dim frm As Form

    ' Instantiate the object variable as an instance
    ' of your form class
    Set frm = New Form_Form1

    ' Call the Sub as a method of the form object
    ' variable.
    frm.MyMethod

End Sub

HTH,

Bob

Oh, and free the heap memory allocated to the form object reference when your done with it:

Set frm = Nothing

Bob's solution, while correct, isn't always necessary. You can simply call the procedure in the form's class module.

E.g. Formname=frmTest, Buttonname=btnOk_Click

Your code would then be
  Call Form_frmTest.btnOk_Click

The form doesn't have to be open to use the code. However, if the code you're using needs the form to be open, you might want to be sure it is open before you call the procedure.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org