Restrict input into cell array
 

Hello,
New to the Excel forum.

I have a question on restriciting the number of inputs into a range of
cells to only a single entry.

I'm building a Lickert-type scale from 0 to 10 (disagree - agree) for a
school pilot study. I have restricted the individual cells to limit
input to the appropriate value for the individual cells of the scale
(e.g. you can only input a 5 into the '5' cell and so on).

I don't know how to make sure that the respondents don't type in more
than a single value within each scale.

If someone has an idea how to do this or what terms to use in Excel
Help the assistence would be much appreciated.

Thanks.

Dan


--
dlp1848
------------------------------------------------------------------------
dlp1848's Profile: http://www.excelforum.com/member.php...o&userid=27558
View this thread: http://www.excelforum.com/showthread...hreadid=470852

I am not sure whjat you are trying to do, but check "cell validation" in help

"dlp1848" wrote:


Hello,
New to the Excel forum.

I have a question on restriciting the number of inputs into a range of
cells to only a single entry.

I'm building a Lickert-type scale from 0 to 10 (disagree - agree) for a
school pilot study. I have restricted the individual cells to limit
input to the appropriate value for the individual cells of the scale
(e.g. you can only input a 5 into the '5' cell and so on).

I don't know how to make sure that the respondents don't type in more
than a single value within each scale.

If someone has an idea how to do this or what terms to use in Excel
Help the assistence would be much appreciated.

Thanks.

Dan


--
dlp1848
------------------------------------------------------------------------
dlp1848's Profile: http://www.excelforum.com/member.php...o&userid=27558
View this thread: http://www.excelforum.com/showthread...hreadid=470852