Combobox inside a multipage inside a frame on a worksheet

[Ploos]

Hi all,

I have a worksheet (sheet1) and it has a frame (frame1). Inside the frame there is a multipage (multipage1) en inside that multipage, on page1 there is a combobox (combobox1). I would like to know the right way to tell VBA how to fill that combobox using a list that's on sheet2.
I know how to do this with regular comboboxes and with comboboxes in frames. But I don't know how to include the multipage.

Please can someone help me??

Kind regards,
Sophie

 

[RoryA]

Welcome to the forum.

You would use something like this:

activesheet.frame1.controls("multipage1").pages(0).controls("combobox1").list = Sheets("Sheet2").range("A1:A5").Value

 

[Domenic]

In this case, it looks like one can also refer to the combobox as follows...

worksheets("Sheet1").Frame1.Controls("ComboBox1").List = Range("A1:A3").Value

 

[Ploos]

Welcome to the forum.

You would use something like this:

activesheet.frame1.controls("multipage1").pages(0).controls("combobox1").list = Sheets("Sheet2").range("A1:A5").Value

You are my hero.. works like a charm. Thanks. I really did not know how to combine that..
Sophie

 

[Ploos]

Tried that but I get a "Subscript out of range" error. Probably because of the multipage control which holds the combobox.

 

[Ploos]

Tried that but I get a "Subscript out of range" error. Probably because of the multipage control which holds the combobox.

-->Domenic

 

[Domenic]

It works for me. Did you you add the controls like this...

Design Mode > right-click the Frame > select Frame object > select Edit > add controls using the Toolbox

???

 

[Ploos]

It works for me. Did you you add the controls like this...

Design Mode > right-click the Frame > select Frame object > select Edit > add controls using the Toolbox

???

Yes. That how I added the multipage and than inside the multipage added the combobox. My multipage contains 5 pages.
Anyways. The other option works So thank you all.

 

[Ploos]

Welcome to the forum.

You would use something like this:

activesheet.frame1.controls("multipage1").pages(0).controls("combobox1").list = Sheets("Sheet2").range("A1:A5").Value

You wouldn't possible know how to adress a commandbutton in that same multipage in that frame on that worksheet? :S Double clicking leads to a "Frame1_click()" which I don't want. I'm sure it can be easy.. but I don't see it.

 

[Domenic]

I forgot to reference Sheet2 for your list. And I'm assuming that the sheet references are correct? In any case, Rory has given you a solution that works, so that's great.