Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Forms--Vista--2007 Excel
Hello, I am working on an Excel Worksheet, using it as a survey, and need to
accomplish 3 tasks. 1.) I want the user to check, or place an "X" only one of three options. (Grouping Radio Buttons may accomplish this task, but I wanted to see if there was a way, we could protect the worksheet, and only allow entering of text in the three options.) 2.) I want the worksheet to indicate if a user has missed a survey question. (For intstance, they place an "X" in of the the three options for Question No. 1, but neglect to do so for Question No. 2.) As a result the worksheet will not save and/or close. 3.) I want the value of the "X" to represent a value. (For example, if they put an "X" in small, it will equal "1", and "X" in medium, it will equal "2", etc.) Since I am dealing with someone else's worksheet, and it is all set up, I just need to add these functions. Is it possible, or do I need to recreate in a User Form (which is over my head anywway)? Any suggestions you may have would be appreciated. Thanks (Lost in Excel). |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 and Office 2007 stink (so does Vista) | Excel Discussion (Misc queries) | |||
.NET RTD on Excel 2007 & Vista | Excel Worksheet Functions | |||
Convert Excel 2007 data forms to Access 2007 ? | Excel Discussion (Misc queries) | |||
Excel 2007 and Vista | Excel Discussion (Misc queries) | |||
Excel 2007 and Vista | Excel Discussion (Misc queries) |