Results 1 to 4 of 4
  1. #1
    chromachem is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    51

    Dim combo As CommandBarComboBox


    When I try to run
    Code:
     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

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    no such thing as CommandBarComboBox
    so do either
    command button
    or
    combobox

  3. #3
    chromachem is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    51
    Thank you.

  4. #4
    chromachem is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    51
    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.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 01-29-2016, 08:52 PM
  2. Replies: 11
    Last Post: 09-03-2015, 11:12 AM
  3. Replies: 2
    Last Post: 10-21-2014, 07:57 AM
  4. Replies: 1
    Last Post: 10-30-2012, 10:29 AM
  5. Replies: 4
    Last Post: 08-16-2011, 05:54 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums