Adding controls in Activex Multi page

[pipoliveira]

Dear All,

I hope you are all well.

I am having some issues on adding controls on a Multi page (Activex) embedded in a worksheet.

Every time I add a control (Command Button or even a Check Box) it won't stay inside the page I want. Instead, it stays outside de Multi page as soon I disable the "Design Mode" button.

There's something I am doing wrong but I can't manage to add anything inside the Multi page.

Any suggestions will be highly appreciated.

Best regards,
Filipe Oliveira

[Leith Ross]

Hello pipoliveira,

1) On the Ribbon click Developer > Design Mode
1) Right Click the MultiPage object.
2) Select MultiPage Object > Edit from the context menu.
3) Right click the MutiPage object.
4) Select Toolbox... from the context menu.
5) Select the control you want to add.

For these controls to perform some task when clicked, you will need to Subclass them.

[pipoliveira]

Hi Leith,

Thanks for your assistance.

It works now. I always worked with User Forms and never with Activex controls such as Multipage, so I was a bit confused on how to add controls into it.

Your help was amazing. Highly appreciated for it.

Thanks a million.
Filipe Oliveira

[pipoliveira]

Hi Leith,

Just one more thing if you can assist. How to add a code to a control? Normally in a User Form you just double click and the VBA editor opens for that control. Here, double clicking does not open the VBA Editor. Should the code be inside the multipage VBA editor? Maybe is what you mentioned as Subclass but cannot understand how to subclass them.

As for an example, let's say I have a command button (CommandButton1) inside the MultiPage1 (Page1). I want to have a code as when I click it, it activates the Sheet2.

On a normal user form the code is simple

Please Login or Register  to view this content.

.

Can you please provide an example of the code or where this code can be added?

Your help was amazing. Highly appreciated for it.

Thanks a million.
Filipe Oliveira