Call a private userform's event

[ktab]

Hello,

Is it possible to call a private userform procedure with the "call" command (or anything else like application.run ) from an outside of the userform, module?
What I mean is that i want, through a procedure called e.g. public sub test() to execute commandbutton18_click event. (button 18 belongs to userform1.

Thank you
Kostas

 

[erik.van.geit]

Hi, Kostas,

yes, you can do that

change "Private" to "Friend" or "Public"

Friend Sub CommandButton1_Click()
MsgBox "This is codemodule """ & Me.Name & ".CommandButton1_Click""", 64, "INFO"
End Sub

in any module use

UserForm1.CommandButton1_Click

kind regards,
Erik

 

[ktab]

Thank you Erik,
I went half way (renamed to public sub commandbutton1_click()) but just called commandbutton1_click() not userform1.commandbutton1_click()

Thank you very much for your assistance

 

[erik.van.geit]

you're WELCOME

going to house n°46 doesn't make much sense ...
you need the street in your address !

street1.house46_click

 

[ktab]

Unless if you are a nomad; All the world is your house

Thanks again