Home

Excel ComboBox (ActiveX Controls) dropdown not functioning

%3CLINGO-SUB%20id%3D%22lingo-sub-807363%22%20slang%3D%22en-US%22%3EExcel%20ComboBox%20(ActiveX%20Controls)%20dropdown%20not%20functioning%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-807363%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20issue%20occurs%20when%20trying%20to%20select%20the%20dropdowns%20for%20ComboBoxes%20on%20this%20Excel%20sheet.%20Everyone%20else%20in%20my%20department%20can%20access%20and%20use%20this%20sheet%20without%20issue.%20However%2C%20when%20I%20select%20any%20of%20the%20ComboBoxes%2C%20right-click%20and%20left-click%20cause%20a%20phantom%20dropdown%20to%20hover%20in%20the%20cells%20above%20the%20ComboBox%20without%20actually%20opening%20the%20dropdown%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20232px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F127194i4276A970A3058AA5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222019-08-15%2014_19_21-SYS_DESIGN_V1%20-%20Excel.jpg%22%20title%3D%222019-08-15%2014_19_21-SYS_DESIGN_V1%20-%20Excel.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20discovered%20that%20I%20can%20edit%20the%20selection%20from%20the%20dropdown%20if%20I%20go%20to%20Developer%20tab%20%26gt%3B%20Design%20Mode%20%26gt%3B%20Right-click%20ComboBox%20%26gt%3B%20ComboBox%20Options%20%26gt%3B%20Edit%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20218px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F127195i4955E478E17B042F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222019-08-15%2014_21_57-SYS_DESIGN_V1%20-%20Excel.jpg%22%20title%3D%222019-08-15%2014_21_57-SYS_DESIGN_V1%20-%20Excel.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThis%20is%20an%20un-optimized%2C%20time-consuming%20solution%20(to%20say%20the%20least)%20when%20I%20should%20be%20able%20to%20make%20these%20same%20selections%20by%20simply%20left-clicking%20the%20dropdowns%20when%20not%20in%20Design%20Mode.%20I'm%20guessing%20that%20this%20is%20an%20issue%20with%20some%20unknown%20Excel%20setting%20since%20the%20ComboBoxes%20only%20misbehave%20this%20way%20on%20my%20laptop%20across%20our%20office.%20The%20sheet%20is%20unprotected%20and%20creating%20new%20ActiveX%20ComboBoxes%20results%20in%20the%20same%20dropdown%20selection%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20this%20forum%20can%20provide%20will%20be%20greatly%20appreciated!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-807363%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EActiveX%20button%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECombo%20Box%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Edropdown%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-807376%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20ComboBox%20(ActiveX%20Controls)%20dropdown%20not%20functioning%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-807376%22%20slang%3D%22en-US%22%3EAlso%20worth%20noting%3A%3CBR%20%2F%3EActiveX%20Trust%20Center%20Settings%20are%20set%20to%20Enable%20all.%3CBR%20%2F%3ESame%20goes%20for%20the%20Macro%20Trust%20Center%20Settings%2C%20but%20there%20haven't%20been%20any%20changes%20after%20enabling%20both%20of%20these.%3C%2FLINGO-BODY%3E
Kpizzle
New Contributor

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:

2019-08-15 14_19_21-SYS_DESIGN_V1 - Excel.jpg

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:

2019-08-15 14_21_57-SYS_DESIGN_V1 - Excel.jpg

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!!

1 Reply
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.
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies