ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   created form, want to require input (https://www.excelbanter.com/excel-programming/305465-created-form-want-require-input.html)

No Name

created form, want to require input
 
I have created a survey form and grouped the 6 responses
to questions allowing the user to only choose one out of
six as a response. Based on which rating is chosen, I'd
like to require a comment to be provided by user.

More specifically, there are 5 ratings from "Very
satisfied" to "Very unsatisfied" plus one rating
of "N/A". If a user chooses unsatisfied or very
unsatisfied, I'd like to require them to comment (in the
cell below the ratings) why they rated that item poorly.

Any suggestions ? Only thing I could think of was to
check for a TRUE response to either "unsatisfied" or "very
unsatisfied", then check the length of characters in
the "comment" cell to see if the length was 0.

Would this work ? Is there an easier way ?


All times are GMT +1. The time now is 02:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com