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:

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

(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:

Please Login or Register  to view this content.

Then in a different Module, not the UserForm module:

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

[walruseggman]

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

Thanks, I learned something today!