Combobox - object not defined

[DG]

I have a spreadsheet that I am testing that has a combobox that I am filling
with an array (MyArray).

In my test workbook the combobox is on Sheet1 and "Sheet1.ComboBox1.List =
MyArray" works to fill the combobox.

However, when I put the combobox in my production spreadsheet where the
sheet is named "Summary" I tried "Summary.ComboBox1.List = MyArray" I get an
error '424' "Object required".

If I use "Sheet5.ComboBox1.List = MyArray" (Sheet5 is the original name of
the sheet) it works. But I don't like using "Sheet5". How do I use the name
"Summary" so 6 months from now I know what I was doing?


Dan

 

[John W. Vinson]

I have a spreadsheet that I am testing that has a combobox that I am filling
with an array (MyArray).

In my test workbook the combobox is on Sheet1 and "Sheet1.ComboBox1.List =
MyArray" works to fill the combobox.

However, when I put the combobox in my production spreadsheet where the
sheet is named "Summary" I tried "Summary.ComboBox1.List = MyArray" I get an
error '424' "Object required".

If I use "Sheet5.ComboBox1.List = MyArray" (Sheet5 is the original name of
the sheet) it works. But I don't like using "Sheet5". How do I use the name
"Summary" so 6 months from now I know what I was doing?


Dan

I'd suggest that you post this question in an Excel newsgroup. This group is
for a different program, Microsoft Access.

John W. Vinson [MVP]