Run code in another private sub 1

[Jusenkyo]

Hello all

I have a few pages of VBA code behind a button on a form, that I want to be able to run from another button on a different form.
I havent used Public classes or whatever, so im not sure how to reference the code from a different procedure.

Anyone?

Cheers
J

 

[irishjoe]

If you have something like;

Private Sub btnClose_Click()
'your code here...
End Sub


change it to;

Private Sub btnClose_Click()
abc
End Sub

private function abc()
'Your code here...
End Function

 

[Jusenkyo]

Can you reference the private function from another form then?

 

[irishjoe]

That will work if you are in the same form.

To make it available to other forms do the following.
private Sub btnClose_Click()
Form_frmMainmenu.abc
End Sub

Public function abc()
'Your code here...
End Function

replace frmMainMenu for the name if your form.

 

[Jusenkyo]

Excellent!

Thanks Joe!