Get Comboboxes in Sheet by MSForms.ComboBox

[Joakim N]

Why do I get an error when I try to get a combobox from a sheet by 'Sub GetComboboxes1()'
It works in 'Sub GetComboboxes2()'

Is it possible to use another collection than OLEObjects when looping through all objects in sheet?

Both subroutines and worksheet objects are stored in GetComboboxes.xlsm

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Joakim N]

I tried following also (GetComboboxes3() and GetComboboxes4()). Still I can't store a combobox to a variable defined as:

Please Login or Register  to view this content.

What am I doing wrong?

Please Login or Register  to view this content.

Please Login or Register  to view this content.