How to run a command button with vba code?

[CVAR23]

Im trying to "click" a button after my form loads but Im not having any success

The button will start a progress bar from "loading", the form I want to load is a splash form. I've tried this...

First I declared the sub of me.cmdSTart public, like this :

Code:
Public Sub cmdStart_Click()
Then I can access the sub from anywhere and on the form load event of the splash screen I write this...but no luck, is this the correct method to do it?

Code:
Me.cmdStart_Click

 

[RickXL]

Hi,

I think you need only something lke this in the UserForm Module:

Private Sub cmdStart_Click()
    MsgBox "Clicked!"
End Sub

Private Sub UserForm_Initialize()
    cmdStart_Click
End Sub

Regards,

 

[CVAR23]

hi! yeah it worked! thanks!!

 

[RickXL]

You're welcome. Thanks for letting me know.

Regards,