Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Require input in a cell before saving file | Excel Discussion (Misc queries) | |||
Require mandatory info input in order for Exel to save changes. | Excel Worksheet Functions | |||
input in number form is being multiplied by 1000 when i input. | Excel Discussion (Misc queries) | |||
Have cell require input before saving. | Excel Discussion (Misc queries) | |||
I created a form on excel. want to edit the form without printing | Excel Discussion (Misc queries) |