Click event in seperate module

[steijssen]

Hello,

I want to put a long list of button_click() events in a seperate module. Is this possible? If so, how? I make the subs public, use the right reference for the fields in my statements.. Do I need to enter something else than:

Public Sub SomeButton_Click()
...
End Sub

Like Public Sub Form1_SomeButton_click() instead of just SomeButton_Click? (I know that one doesn't work, tried it already)

Thanks for helping me out on this!

 

[Norris68]

Not unless you either write code in each standard event handler to call your public subs (defeats the object) or subclass the application event handler and redirect the events from there (plenty of source code available on the web)

 

[CajunCenturion]

What I would suggest is to leave the event handlers in the form to which the button applies. However, you can put all of your code into a module, and all the event handler does is call that routine. This also allows you to have different buttons on different forms actually execute the the same code. Here's a quick example.

In a Module
------------

Public Sub TheButton1Logic ()

<The applicable code for your application>

End Sub


In Form 1
---------

Private Sub cmdButton1_Click

TheButton1Logic

End Sub

In Form 2
---------

Private Sub cmdButton1_Click

TheButton1Logic

End Sub

and of course you can extend that as your needs require Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[steijssen]

ok thanks very much guys 'n gals!