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
Increase the limit of dropdown items in MS Forms
Josette Moore in Microsoft Forms on
15 Replies
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies
changing Date format in a pivot table
ahmad ali in Excel on
12 Replies
runtime error 1004 : Method range of object - 'Global' failed
Lorenzo Kim in Excel on
16 Replies
INDEX & MATCH interrupted by Inconsistent Dates
shade206 in Excel on
18 Replies