Hi Everyone,
I have a user form that contains a multi-page object in it and each page has some buttons and textboxes on it. I wanted to put this multipage object directly embedded into the spreadsheet and I just recently found out that i could insert a multi-page object directly into a spreadsheet by clicking view->Toolbars->ControlToolbox, then clicking the "More controls" icon and then selecting Microsoft Forms 2.0 MultiPage.
Unfortunately, however, I can't figure out how to assign code to events that occur to objects in the multipage. For example, if I create a command button, I cannot figure out how to create a click event associated with that button. There must be a way to do it, but it seems that the only events that gets recognized are events that happen directly to the MultiPage object and not to any objects contained within it.
So for example, the multipage's click event works whereas a command button, contained within the mulitpage, cannot have button click code associated with it. If you go into design mode and double click on the button, you are not brought to the VBE (like you normally would). And the macro recorder does not record actions that occur to the embedded multipage object.
Does anyone know how I can get these events to register? I would really like to migrate my mutlipage from the userform to directly into the spreadsheet.
Thanks,
-Taylour
I have a user form that contains a multi-page object in it and each page has some buttons and textboxes on it. I wanted to put this multipage object directly embedded into the spreadsheet and I just recently found out that i could insert a multi-page object directly into a spreadsheet by clicking view->Toolbars->ControlToolbox, then clicking the "More controls" icon and then selecting Microsoft Forms 2.0 MultiPage.
Unfortunately, however, I can't figure out how to assign code to events that occur to objects in the multipage. For example, if I create a command button, I cannot figure out how to create a click event associated with that button. There must be a way to do it, but it seems that the only events that gets recognized are events that happen directly to the MultiPage object and not to any objects contained within it.
So for example, the multipage's click event works whereas a command button, contained within the mulitpage, cannot have button click code associated with it. If you go into design mode and double click on the button, you are not brought to the VBE (like you normally would). And the macro recorder does not record actions that occur to the embedded multipage object.
Does anyone know how I can get these events to register? I would really like to migrate my mutlipage from the userform to directly into the spreadsheet.
Thanks,
-Taylour