VBA to click button of another userform?

[ShieBoon]

Hi all,

I have two userforms open at the same time. And i want a particular code of the active userform to

First, unload itself. (Code: Unload Userform1)
Second, click a button in the second userform. (Userform2)
(Code: button1_Click)

But an error prompts, "Sub or Function not defined" when i try to run the entire code. 'Button1_Click' is highlighted. I tried changing button1's click event from private to public but still unable to work.

Any ideas?

excel2003
Shie Boon
Thanks

 

[Norie]

What does the click event on the other userform do?

Have you considered moving it's code to a separate sub?

Then you could call that sub from the click event of the form it's on and from the other form.

 

[ShieBoon]

Hi Norie, thanks for the reply. I found out the problem already though, i added the other userform's name infront of the code.

userform2.button1_Click

It was weird though because it didn't work yesterday. Today it did.

 

[marcnz]

I had the same issue until I realized that by default, the methods (Sub) on a form are of type "Private"... No matter how you call the methods on the other user form, it won't work until you change the word "Private" to "Public"

frmName.SubName, ie frmUser1.cboStates_Change

And make sure the Sub on the frmUser1 for the cboStates_Change is "Public". Now this sub can be called from any other object in the workbook.

Et Voilà!