How to call a button sub in a userform, from a module

[nando88]

I would like to simulate a userform button click from within a module in VBA, but I don't know if this is possible. I tried calling the button click sub from the userform and I am getting invalid procedure.
Can someone please let me know if this is possible?
Thanks in advance.

 

[HaHoBe]

Hi nando88,

you would need to change the button code from Private to Public and use (change to suit)

  UserForm1.CommandButton1_Click

But wouldn't it be better to export the code from the button a standard module?

Ciao,
Holger