Forum Discussion
Writing an option on "other" in drop down list?
Hi. I have been able to create a drop down list for people to choose an option, on the spreadsheet. However, If an option is missed out, I'd like to give the option for someone to write their option. Hence, if they choose "other", they get prompt to provide some form of text, to indicate what "other" is. It would need to be mandatory to fill out an option, and not have the option of just leaving it as "other". Please advise? Thanks
2 Replies
Hi Sina,
I have attached a workbook that you will find inside it an example of what you are asking for?
It contains a multiple choices question, If a user chooses "Other", he will be prompted to enter what " other" is in the below cell.
To make this as mandatory as possible, I have supported it with some lines of code to prevent a user from closing the workbook until he writes something if he has chosen "Other"?
Thank you Haytham. Works perfectly.
