Calling a sub from a different userform

[domnisignis18]

Hi All,

I'm having trouble with a userform calling subs.

In Userform1:

Private sub CommandSubmit_Click()
SubmitForm.Show
End Sub
This shows userform2 which lets the user confirm submission or cancel to go back. When the submit button is clicked:

Private Sub CommandSubmit_Click()
Call SubmitDataTrue_Change
End Sub
This calls a sub from the code of userform1, but if I test and click submit, I get an error "compile error sub or function not defined"

I hope this is enough info. Thanks for the help in advance!

[Norie]

All Subs in userforms are declared as Private by default, as you can see in the code you posted.

That means that they are out of scope to other subs and can't be called from them.

Why do you want to call the other userform's change event?

That's kind of unusual.

PS Can you use code tags when posting code? Makes it easier to read and copy.

[domnisignis18]

It's really more out of ignorance than anything else. I just learned VBA recently. I've already tried changing the sub to

Please Login or Register  to view this content.

but the error remained.

The second userform serves as a pop up prompting a user to check the data before submitting to a protected workbook as they cannot access the worksheet itself. There are probably better ways to accomplish this for all I know.

As for

Please Login or Register  to view this content.

I don't know if I even needed the

Please Login or Register  to view this content.

event as part of the sub.

Any suggestions?

Thanks!

[Norie]

Sorry, I'm a little confused.

Why do you want to call the sub in the other userform?

What does it do?

Can whatever it does only be done in that sub?

[domnisignis18]

Changed to a

Please Login or Register  to view this content.

Thanks for the help though. I knew I was going about it in a roundabout way.

[Norie]

Mmm, still confused and not sure how I 'helped'.

But, hey if you've found a solution that's the important thing.