Loop Worksheet Combo Boxes

Hi all,

I am working with some worksheet combo boxes and I am having troubles with loading values into them using a loop. The code:

Please Login or Register  to view this content.

Can anyone tell me why this is be so darned stubborn?

Supashi-bo

Hi Mordred,

Please Login or Register  to view this content.

Unless your code is in the worksheet's class module, you'll also need to qualify the OLEObjects property, eg.

Please Login or Register  to view this content.

Assuming they are ActiveX comboboxes.

They are ActiveX comboboxes. Thanks guys, I will try this right now!

That fixed it Colin, thank you!

Please Login or Register  to view this content.

was the answer!
Much appreciated!

Michael

You don't need any loop.
You'd better avoid additem to populate comboboxes/listboxes.

Please Login or Register  to view this content.

Hi snb, why avoid .AddItem? Here is the code for a combobox clear and then refill that I am troubled by:

Please Login or Register  to view this content.

Additem isn't designed for populating listboxes/comboboxes; .list is. And additem is terribly slooooooow...
If you use .List you won't need to use .clear, because .list replaces the Listbox's whole content.
This suffices:

Please Login or Register  to view this content.

Originally Posted by snb

Additem isn't designed for populating listboxes/comboboxes

Really? On what do you base that statement?