Calling commandbutton_click event from a module

[aman1234]

I have written the code on the commandbuttons click event and the code is present in the userform . Now Just wondering if its possible to call commandbutton_click event from the module. Like is there any way I can use from the module:

call commandbutton1_click

Thanks

[Leith Ross]

Hello aman1234,

You can call code in a module from the CommandButton's Click event on the UserForm. Doing the reverse doesn't make sense. What do want to achieve?

[walruseggman]

Removed because 6StringJazzer has much better / more correct info below.

[6StringJazzer]

You most certainly can call that code from any other module, but I discourage it. To do this, you must make sure it is declared as Public:

Public Sub CommandButton1_Click()
   MsgBox "You pushed the button!"
End Sub

(If you create the code by double-clicking the button on the form designer, it will default to Private.)

This is not a good programming practice. Actions taken based on user events should be distinguished from programmatic actions. In the case where you want to share a function, then it is better to create a new common Sub and call that from the form and wherever else you want to use it.

This code goes in your UserForm module:

Public Sub CommandButton1_Click()
   MsgBox "You pushed the button!"
   DoSomething
End Sub

Then in a different Module, not the UserForm module:

Public Sub DoSomething()
   MsgBox "This code is now Doing Something"
End Sub

And then from the other place you want to call it:

   MsgBox "The code is doing this, not a user"
   DoSomething

[walruseggman]

@6StringJazzer: you're absolutely right, you can call the sub. I stand corrected and agree with your approach.

Thanks, I learned something today!