Restrict input into cell array

[dlp1848]

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

[bj]

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