Dim combo As CommandBarComboBox

[chromachem]

When I try to run

 Dim combo As CommandBarComboBox

I get the error message Compile error: User-defined type not defined.


I found the code online.
There is a comment mentioning that the Dim statement requires a reference to the Microsoft Object Library.

VBA - Tools- References shows Object Library 14 as checked.

Any help is greatly appreciated.

Thanks

[ranman256]

no such thing as CommandBarComboBox
so do either
command button
or
combobox

[chromachem]

Thank you.

[chromachem]

Update: CommandBarCombo box may be dimmed by:

Go to VBA Selec tools, references

Select Microsoft OFFICE 14.0 Object Library.


Access Library had been selected by default. Finally noticed there was an OFFICE Object Library as well.