I am struggling to figure out how to detect a button press event on a MultiPage form that resides directly on an Excel sheet. The form is not generated using VBA, it is built directly on the sheet using Developer > Insert > ActiveX Controls > More Controls > Microsoft Forms 2.0 MultiPage.
I expect the syntax to be something like:
I can't believe Microsoft would provide functionality for building a form like this without an ability to detect and react to a button press. Any help would be greatly appreciated!
Thank you!
I expect the syntax to be something like:
Private Sub MultiPage1_Page1_Frame1_CommandButton1_Click()
Do Stuff
End Sub
which is analogous to
MultiPage1.Page1.Frame1.TextBox1 = "Some Text"
that works just fine... In other words, I can set values for text boxes or combo boxes on this form, I just can't capture a button press event for a button in the form.