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....
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.