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
force metadata when uploading files
Robert Lien in SharePoint on
10 Replies
Need help with formating colors based on time in columns
288088 in SharePoint on
18 Replies
Modern news web part any way to hide author
Theodor Ammerind in SharePoint on
6 Replies
Importing a spreadsheet into a SP Online list
Jlee_Prosci in SharePoint on
2 Replies
Column Validation - SharePoint Online List
Sam1209 in SharePoint on
1 Replies
Sharepoint Subcategories
dchatman in SharePoint on
9 Replies