Forum Discussion

Kpizzle's avatar
Kpizzle
Copper Contributor
Aug 15, 2019

Excel ComboBox (ActiveX Controls) dropdown not functioning

Hello all,

 

My issue occurs when trying to select the dropdowns for ComboBoxes on this Excel sheet. Everyone else in my department can access and use this sheet without issue. However, when I select any of the ComboBoxes, right-click and left-click cause a phantom dropdown to hover in the cells above the ComboBox without actually opening the dropdown:

I discovered that I can edit the selection from the dropdown if I go to Developer tab > Design Mode > Right-click ComboBox > ComboBox Options > Edit:

This is an un-optimized, time-consuming solution (to say the least) when I should be able to make these same selections by simply left-clicking the dropdowns when not in Design Mode. I'm guessing that this is an issue with some unknown Excel setting since the ComboBoxes only misbehave this way on my laptop across our office. The sheet is unprotected and creating new ActiveX ComboBoxes results in the same dropdown selection issue.

 

Any help this forum can provide will be greatly appreciated!!

  • Arjan_Bouwhuis's avatar
    Arjan_Bouwhuis
    Copper Contributor
    Hello all,

    Does anyone have a solution for this issue? I'm also having the same problem and I haven't found any fixes yet. Any help will be really appreciated!

    Best regards
  • gabisker's avatar
    gabisker
    Copper Contributor

    Kpizzle  I am having the exact same problem. Did you find any fixes or hints to what may be causing this behaviour?

     

    Best regards

  • Kpizzle's avatar
    Kpizzle
    Copper Contributor
    Also worth noting:
    ActiveX Trust Center Settings are set to Enable all.
    Same goes for the Macro Trust Center Settings, but there haven't been any changes after enabling both of these.

Resources