Loading an on sheet ActiveX combo with an array?

G

Gary McMaster

Well-known Member
Joined
Feb 8, 2009
Messages
1,978
Hi Everyone,

I can use the following to load a combobox on a user form with an array.

Code: 
UserForm1.ComboBox1.List = MyArray

The following fails when the combo is placed directly on the sheet:

Code: 
ActiveSheet.OLEObjects("ComboBox1").List = MyArray

Is there a way to load the array directly into the combo box without dumping the data onto the worksheet and setting the "ListFillRange"?

Thanks in advance for your advice.

Gary
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
Sort by date Sort by votes
PGC,

Thanks very much for your reply. Obviously ".object" was the missing piece of the puzzle.

I couldn't get this to work either:

Code: 
Dim oCBO As ComboBox

Set oCBO = ActiveSheet.OLEObjects("ComboBox1")

Adding ".object" on the end fixes that too.

Thanks again,

Gary
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question Question
User form successfully ran but no results are showing
Replies
1
Views
311
rlv01
R
S
  • Question Question
Sorting data from one sheet to multiple others
Replies
0
Views
317
saeriefaeriexx
S
B
  • Solved
Need VBA solution for getting Excel to load videos files onto PowerPoint slides
Replies
2
Views
992
bc4240
B
T
  • Question Question
How can i refresh the list in one active x combo box when another is triggered?
Replies
1
Views
870
GWteB
GWteB
J
  • Question Question
Fastest way to load column range from a closed workbook into an array
Replies
4
Views
4K
johnnyL
J

Forum statistics

Threads
1,224,592
Messages
6,179,787
Members
452,942
Latest member
VijayNewtoExcel

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top