Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default 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 ?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Require input in a cell before saving file Patrick Riley Excel Discussion (Misc queries) 21 March 26th 08 02:47 PM
Require mandatory info input in order for Exel to save changes. VHG Excel Worksheet Functions 3 May 31st 07 12:40 PM
input in number form is being multiplied by 1000 when i input. jweinograd Excel Discussion (Misc queries) 4 April 16th 07 11:18 PM
Have cell require input before saving. couriced Excel Discussion (Misc queries) 1 October 20th 05 04:36 PM
I created a form on excel. want to edit the form without printing Oz Excel Discussion (Misc queries) 1 September 1st 05 08:18 PM


All times are GMT +1. The time now is 10:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"