How to virtually click a button in a userform using VBA

Question

I have a userform with 4 buttons.

I want to start the userform with button 1 already active.

The button is a public sub called "StartMeasButton_Click()" and is inside the userform. I need to click on that button.

I tried the Application.Run method but it fails, as I've understood, as the method is for a spreadsheet command button and not for a userform inside button.

Please read Under what circumstances may I add “urgent” or other similar phrases to my question, in order to obtain faster answers? - the summary is that this is not an ideal way to address volunteers, and is probably counterproductive to obtaining answers. Please refrain from adding this to your questions. — halfer
– halfer, Commented Oct 18, 2018 at 17:53

Harassed Dad · Accepted Answer · 2018-10-18 13:54:06Z

1

Simplest solution: Make your button click call a subroutine, then you can call the subroutine whenever you want to "click" the button.

 Sub StartMeasButton_Click()
     MySubRoutine
 End Sub

 Sub MySubRoutine()
   'put the body of your click routine here
 End Sub

 Sub Form1_Initialise
     MySubRoutine  'effectively the same as clicking the button
  End Sub

answered Oct 18, 2018 at 13:54

Harassed Dad

4,7141 gold badge12 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

miken32 · Accepted Answer · 2023-05-29 18:33:41Z

1

If you want to use code to "click" or "press" a command button just set the value to true. This will fire the commandbutton's code events.

UserForm1.CommandButton1.Value = True

edited May 29, 2023 at 18:33

miken32

42.5k16 gold badges127 silver badges177 bronze badges

answered May 29, 2023 at 18:29

Mike Loepold

111 bronze badge

1 Comment

Mike Loepold Over a year ago

miken32 while your edit is polite. The issue remains. OP questions need to be addressed more directly. I honestly think it'd be better to just delete this answer.

Daniel Penteado · Accepted Answer · 2023-07-19 03:03:28Z

0

If it's allways the same "StartMeasButton" button, you can simply write a line like this:

StartMeasButton_Click

However, it can be dynamically generated if you use the "CallByName" method:

CallByName objForm, objButton.Name & "_Click", VbMethod

answered Jul 19, 2023 at 3:03

Daniel Penteado

1

Collectives™ on Stack Overflow

How to virtually click a button in a userform using VBA

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related