You can certainly do all this. It will take a bit of work though. To get
started, look at data validation:
http://www.contextures.com/xlDataVal01.html

http://www.ozgrid.com/Excel/data-validation.htm

http://excel.tips.net/E165_Data_Validation.html

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Lost in Excel" wrote:

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