Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: ComboBox issue with properties and name missing

  1. #1
    New Member
    Join Date
    Dec 2014
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default ComboBox issue with properties and name missing

    Has anyone had an issue where their ComboBoxes in Debug mode do not have properties? It's like they don't even exist, when I right click on the box. I ran a Workbook_Open subroutine and it continues to fail due to Run-time error '438' Object doesn't support this property or method. When I walked through my code, I noticed it wasn't connecting with the ComboBox name.

    This apparently has only been an issue with some users, so perhaps it could be a setting issue of some kind. Any suggestions? Thanks a lot.

  2. #2
    New Member
    Join Date
    Dec 2014
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: ComboBox issue with properties and name missing

    Hi,
    I'm experiencing exactly the same issue for last two days. Most probably the combobox inserted is an ActiveX object. After update, some security settings for activex were changed.
    To find out, whether the actual object in excel is of ActiveXtype, switch on the design mode and click on the object. If it does display =EMBED("Forms.ComboBox.1";"") in the excel formula filed, then this object is an external activex object (therefore embedded into the excel file). If you use other language version, than the work EMBED may be translated (pain in the a..).
    Can you insert new activex object into excel document? (Under the troublesome user account, in excel design mode, try to insert new ActiveX control).

    I solved this by the first option, but basically, you have two:
    1. reinsert the combobox object as Form control (intead of activeX control) and rewrite the VBA code. (What I used)
    2. try to adjust the activex settings in inetcpl.cpl

    You should go the first way, since this should prevent future issues. If you choose this approach, see quick reference on the VBA excel-form-combobox at:
    Working with combo boxes (Form Control) using vba | Get Digital Help - Microsoft Excel resource

    Good luck.
    Martin Svojsik

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •