Calling commandbutton_click event from a module

[aman]

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 want I can use from the module:

call commandbutton1_click

Thanks

 

[CJ_London]

if 'the module' is the same form module as commandbutton1_click then yes you can.

If it is a different module you need to replace private with public for the commandbutton1_click sub and the form itself needs to be open.

And to call it you would use

Form_whatevermyformiscalled.commandbutton1_click

 

[CJ_London]

just realised from your other post that you are working in Excel, not Access so I don't know if my suggestion would work

you could put the code behind the button in a general module and then you can call it from anywhere (providing it is not referencing anything on the form)