SOLVED

Some Multiple Option feeding in forms

%3CLINGO-SUB%20id%3D%22lingo-sub-2385979%22%20slang%3D%22es-ES%22%3ESome%20Multiple%20Option%20feeding%20in%20forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2385979%22%20slang%3D%22es-ES%22%3E%3CP%3EIs%20there%20any%20possibility%20that%20in%20a%20form%20some%20cells%20are%20previously%20defined%20as%20multiple%20choice%20and%20the%20user%20can%20select%20only%20one%20of%20the%20available%20options%20when%20filling%20out%20the%20form%3F%20Columns%20marked%20with%20red%20in%20the%20attached%20image.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2385979%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2386000%22%20slang%3D%22en-US%22%3ERe%3A%20Some%20Multiple%20Option%20feeding%20in%20forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2386000%22%20slang%3D%22en-US%22%3EYou%20are%20working%20with%20built%20in%20Form%20and%20has%20limited%20scope%2C%2C%2C%20along%20with%20VBA%20driven%20User%20Form%20selection%20from%20multiple%20Items%20is%20possible%20like%20using%20COMBO%20%26amp%3B%20LIST%20box%20controls!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2388624%22%20slang%3D%22en-US%22%3ERe%3A%20Some%20Multiple%20Option%20feeding%20in%20forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2388624%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F93699%22%20target%3D%22_blank%22%3E%40Rajesh-S%3C%2FA%3E!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2390348%22%20slang%3D%22en-US%22%3ERe%3A%20Some%20Multiple%20Option%20feeding%20in%20forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2390348%22%20slang%3D%22en-US%22%3EGlad%20to%20help%20you%2C%2C%20if%20my%20solution%20works%20for%20you%20then%20you%20may%20mark%20it%20as%20Best%20answer%20as%20well%20Like%2C%2C%2C%20and%20keep%20asking%20%E2%98%BA%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
New Contributor

Is there any possibility that in a form some cells are previously defined as multiple choice and the user can select only one of the available options when filling out the form? Columns marked with red in the attached image.

5 Replies
best response confirmed by HugoEPorras (New Contributor)
Solution
You are working with built in Form and has limited scope,,, along with VBA driven User Form selection from multiple Items is possible like using COMBO & LIST box controls!

Thank you @Rajesh-S

Glad to help you,, if my solution works for you then you may mark it as Best answer as well Like,,, and keep asking ☺
Do you know some video in YouTube that shows COMBO & LIST box controls with VBA? I know very little about VBA.