Issue with a dynamic dropdown - secondary value not displayed

%3CLINGO-SUB%20id%3D%22lingo-sub-2626032%22%20slang%3D%22en-US%22%3EIssue%20with%20a%20dynamic%20dropdown%20-%20secondary%20value%20not%20displayed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2626032%22%20slang%3D%22en-US%22%3E%3CP%3EOS%3A%26nbsp%3B%20MS%20Windows%2010%3C%2FP%3E%3CP%3EExcel%20version%201908%20Build%2011929.20946%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20built%20a%20dynamic%20drop%20down%20menu%20with%20the%20following%20values%20in%20a%20table%20named%20%22Expense%20_Category_List%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22225%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22225%22%3EPayments%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EReprints%2FEducation%20Materials%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20a%20user%20selects%20Reprints%2FEducation%20Materials%20the%20next%20dropdown%20should%20dynamically%20display%20the%20value%20%22Reprints%2FEducation%20Materials%22%2C%20however%20it's%20not%20working.%26nbsp%3B%20The%20second%20menu%20will%20not%20display%20any%20values.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20Name%20Manager%20I%20have%20an%20entry%20named%20%22Reprints%22%20that%20refers%20to%20Table%2037%5BReprints%2FEducational%20Materials%5D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20the%20issue%20is%20with%20the%20'%2F'%20in%20the%20Expense_Category_List%20value%20but%20I'm%20not%20sure.%26nbsp%3B%20I%20cannot%20rename%20this%20value%20to%20anything%20else%20because%20there%20are%20other%20functions%20that%20are%20depending%20on%20receiving%20this%20value%20as%20named.%26nbsp%3B%20Is%20there%20anything%20I%20can%20do%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20feeling%20this%20is%20because%20of%20the%20%22%2F%22%20in%20the%20name%20of%20the%20value%20%22Reprints%2FEducation%20Materials%22.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2626032%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2650799%22%20slang%3D%22en-US%22%3ERe%3A%20Issue%20with%20a%20dynamic%20dropdown%20-%20secondary%20value%20not%20displayed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2650799%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1123604%22%20target%3D%22_blank%22%3E%40Omi_B_650%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20stated%3A%3C%2FP%3E%3CP%3E%3CSTRONG%3EI've%20built%20a%20dynamic%20drop%20down%20menu%20%5B%3CEM%3Eusing%20what%20method%3F%20ActiveX%3F%20FormControl%3F%20DataValidation%3F%3C%2FEM%3E%5D%26nbsp%3B%3CSPAN%3Ewith%20the%20following%20values%20in%20a%20table%20named%20%22Expense%20_Category_List%22%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EPlease%20don't%20keep%20us%20in%20suspense%20by%20giving%20us%20a%20hint%20on%20the%20above%20before%20we%20can%20continue%20reading%20the%20rest%20of%20your%20narrative.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

OS:  MS Windows 10

Excel version 1908 Build 11929.20946

 

I've built a dynamic drop down menu with the following values in a table named "Expense _Category_List"

 

Payments
Reprints/Education Materials

 

If a user selects Reprints/Education Materials the next dropdown should dynamically display the value "Reprints/Education Materials", however it's not working.  The second menu will not display any values.

 

In Name Manager I have an entry named "Reprints" that refers to Table 37[Reprints/Educational Materials]

 

I think the issue is with the '/' in the Expense_Category_List value but I'm not sure.  I cannot rename this value to anything else because there are other functions that are depending on receiving this value as named.  Is there anything I can do?

 

I have a feeling this is because of the "/" in the name of the value "Reprints/Education Materials".  

0 Replies