SOLVED

Dropdown list for suggestions

%3CLINGO-SUB%20id%3D%22lingo-sub-1856547%22%20slang%3D%22en-US%22%3EDropdown%20list%20for%20suggestions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1856547%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3CBR%20%2F%3EI%20would%20like%20to%20use%20a%20dropdown-list%20in%20combination%20with%20a%20free%20text.%20Is%20this%20possible%3F%20If%20yes....%20how%3F%3C%2FP%3E%3CP%3EIn%20the%20next%20step%20I%20would%20like%20to%20add%20the%20new%20text%20to%20my%20dropdown%20list%20automatically%20(for%20the%20next%20cells).%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20support!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1856547%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1856757%22%20slang%3D%22de-DE%22%3ESubject%3A%20Dropdown%20list%20for%20suggestions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1856757%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F857960%22%20target%3D%22_blank%22%3E%40thank_you144%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EIf%20I%20have%20correctly%20understood%20the%20translation%20of%20your%20text%2C%20this%20is%20the%20easiest%20way.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ETo%20do%20this%2C%20go%20to%20%22Error%20Message%22%20in%20the%20validity%20menu%20and%20set%20the%20type%20to%20%22Warning%22%20or%20%22Information%22%20instead%20of%20%22Stop%22.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EEnclosed%20the%20file%20with%20the%20example%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

Hello, 
I would like to use a dropdown-list in combination with a free text. Is this possible? If yes.... how?

In the next step I would like to add the new text to my dropdown list automatically (for the next cells). 

Thank you for your support!

1 Reply
Best Response confirmed by thank_you144 (Visitor)
Solution

@thank_you144 

If I have correctly understood the translation of your text, this is the easiest way.

 

To do this, go to "Error Message" in the validity menu and set the type to "Warning" or "Information" instead of "Stop".

 

Enclosed the file with the example

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.