Call of Private SUB from Different module & Sheet.

[Raghava@rock]

Hi Team,

Hope you all are doing great ...

I have a cammand button to be Intiated i worksheet name "Cost" , which will show userform1 and abutton in userform to click.

I want a vba code to auto click the command in worksheet and let it populate the userform and also click on the button on user form.

plz respond quickly ...

Regards
Raghava

 

[Hui]

Raghava

Can you post a sample file

When should the Userform be displayed?

 

[Raghava@rock]

Hi Hui,

I have uploaded exact replica of the action( not code ) All i need is to call very basic sample , in this all i want is to call the Userform & auto enable the Click button on the userform in Macro 1 in module 2.

 

[Hui]

I'm not really sure what your asking ?

But you can run the commandbutton1_Click event from anywhere using:

userform1.CommandButton1_Click

You don't have to open the userform