Add Objects to MultiPage Object on Worksheet

[bs0d]

I've drawn a MultiPage object on a spreadsheet. I'd like to add objects on each page of the MultiPage object., but I don't see that it can be done through the Excel interface.

I've drawn the objects I need onto the sheet (various lables and such). And I planned to just change their contents based on which tab is clicked on the multipage. However, the root of my problem is getting the items to appear on top of the MultiPage. Specifically, buttons and labels will not appear on top, as desired when in design mode. When I exit design mode, MultiPage is always on top.

Any thoughts to fix this? Do I need to add the objects via VBA in a one-time code execution?

 

[Norie]

Right click the multipage, goto Multipage Object>Edit.

Right click the multipage again and select Toolbox...

You can now add controls from the toolbox to the pages of the multipage.

 

[bs0d]

Thanks Norie. I like the easy solutions! The downside seems to be needing redundant objects, unless there's a way to make each tab utilize the same listbox, for example.

 

[bs0d]

One more question - How do you access the objects within? For example, I use to populate my listbox this way:

 Sheets("Sheet1").lstComments.List = Application.Transpose(myResults.GetRows)

I added a MultiPage: MultiPageComments, with listbox: lstComments
If I try to populate the new listbox via code below:

 Sheets("Sheet1").MultiPageComments.Page1.lstComments.List = Application.Transpose(myResults.GetRows)

I get a Run-time 438 error: Object does not support this property or method.

 

[bs0d]

here's the correct code:

Sheets("Sheet1").MultiPageComments.Pages(0).lstComments.List = Application.Transpose(myResults.GetRows)

New problem -- Can I add a click event to the listbox within the tab of the MultiPage?

 

[bs0d]

In the event anyone follows this thread seeking a similar solution, you can add click events to MultiPage objects, but must do so with an event handler and Class module. Here are two references I used:

http://www.mrexcel.com/forum/excel-questions/481043-programmatically-add-listbox-event.html
Preparations