simulate click of commandbutton

[birdman]

is there vba code to automatically click a commandbutton if a userform appears?

this will not happen all the time. so i will have an if statement saying if this is true, click the commandbutton. thanks for any help in advance.

 

[Norie]

Steve

Is the command button on the userform?

What are you actually trying to do?

Private Sub CommandButton1_Click()
    MsgBox 1
End Sub

Private Sub UserForm_Initialize()
    CommandButton1_Click
End Sub

 

[MichaelRo]

Depends on what you want to achieve

If you want to access the code within a command button simply call it:

Call CommandButton1_Click

 

[birdman]

yes the commandbutton is on the userform. i just need to commandbutton to be clicked as soon as the userform appears if a certain condition is true.

so if a condition is true, the userform appears and the button is clicked immediately to run the program.

if a condition is false, the userform appears and the user must click that same button to continue the program.

thanks for the response. i will try the provided code.

 

[MichaelRo]

If the condition is true do you need to show the userform at all??

 

[birdman]

i did plan to have the userform showing as the program was being run.

this program will analyze files in 2 separate folders, folder A and folder B.

if there are only files in folder A, userform A will open and the user can select certain things to do and click continue to analyze the files.

if there are only files in folder B, userform B will open and the user can select certain things to do and click continue to analyze the files.

if there are files in both folder A and folder B, userform A will appear, the user will select certain things to do and click continue. at this point userform B will appear, the user will select certain things to do and click continue. then userform A will reappear and the analysis will begin for folder A. once everything associated with userform A is complete, userform B will appear again and complete the analysis for folder B.

right now, when userform A and B reappear the second time, i need to click continue for the analysis to begin.