Home

Radio Buttons interfere with Dropdown lists

%3CLINGO-SUB%20id%3D%22lingo-sub-550817%22%20slang%3D%22en-US%22%3ERadio%20Buttons%20interfere%20with%20Dropdown%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-550817%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20built%20a%20very%20complicated%20macro-free%20workbook%20and%20in%20one%20reporting%20worksheet%20I%20have%20three%20drop%20down%20lists%20to%20select%20the%20information%20(ie%20main%20categories)%20that%20is%20displayed.%26nbsp%3B%20Everything%20worked%20fine%20with%20a%20drop%20down%20list%20on%20the%20Cat2%20table%20to%20select%20more%20information%20as%20needed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20then%20decided%20to%20tweak%20the%20sheet%20and%20added%20a%20series%20of%20radio%20buttons%20(about%2020)%20to%20select%20from%20the%20displayed%20information%20rather%20than%20suing%20a%20second%20drop%20down%20list%20to%20display%20more%20details%20(sub-categories)%20from%20the%20radio%20button-selected%20category.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESince%20adding%20the%20radio%20buttons%20to%20the%20worksheet%2C%20the%20arrows%20on%20the%20three%20Category%20drop-down%20list%20boxes%20no%20longer%20display%20properly.%26nbsp%3B%20The%20arrow%20shows%20up%20when%20selecting%20the%20cell%2C%20but%20disappear%20when%20I%20move%20the%20mouse%20pointer%20over%20to%20the%20drop%20down%20arrow.%26nbsp%3B%20The%20drop%20down%20indicator%20reappears%20after%20randomly%20selecting%20a%20few%20radio%20buttons%2C%20and%20is%20actually%20visible%20in%20the%20attached%20screenshot.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHas%20anyone%20else%20come%20across%20this%20issue%2C%20and%20any%20ideas%20how%20to%20fix%20it.%26nbsp%3B%20I%20am%20using%20Excel%20in%20Office%20365%202016%20version.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F112665i85D73DAC23C97658%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Excel%20Screenshot.png%22%20title%3D%22Excel%20Screenshot.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-550817%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-551066%22%20slang%3D%22en-US%22%3ERe%3A%20Radio%20Buttons%20interfere%20with%20Dropdown%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-551066%22%20slang%3D%22en-US%22%3EWhat%20type%20of%20dropdown%20is%20this%2C%20from%20Data%2C%20Validation%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-552175%22%20slang%3D%22en-US%22%3ERE%3A%20Radio%20Buttons%20interfere%20with%20Dropdown%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-552175%22%20slang%3D%22en-US%22%3EHi%20Jan%20Yes%2C%20the%20dropdown%20is%20from%20the%20Data%20Validation%20tool%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-553429%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Radio%20Buttons%20interfere%20with%20Dropdown%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-553429%22%20slang%3D%22en-US%22%3EHmm.%20controls%20often%20cause%20havoc%20on%20sheets%2C%20I%20would%20revert%20to%20using%20entries%20in%20cells%20instead.%3C%2FLINGO-BODY%3E
Geoff1951
Occasional Contributor

I have built a very complicated macro-free workbook and in one reporting worksheet I have three drop down lists to select the information (ie main categories) that is displayed.  Everything worked fine with a drop down list on the Cat2 table to select more information as needed.

 

I then decided to tweak the sheet and added a series of radio buttons (about 20) to select from the displayed information rather than suing a second drop down list to display more details (sub-categories) from the radio button-selected category.

 

Since adding the radio buttons to the worksheet, the arrows on the three Category drop-down list boxes no longer display properly.  The arrow shows up when selecting the cell, but disappear when I move the mouse pointer over to the drop down arrow.  The drop down indicator reappears after randomly selecting a few radio buttons, and is actually visible in the attached screenshot.

 

Has anyone else come across this issue, and any ideas how to fix it.  I am using Excel in Office 365 2016 version.

 

Excel Screenshot.png

3 Replies
What type of dropdown is this, from Data, Validation?
Hi Jan Yes, the dropdown is from the Data Validation tool
Hmm. controls often cause havoc on sheets, I would revert to using entries in cells instead.
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 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
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies