How do I force only one entry in a range?
 

I have to have te user select a test they performed on a patient, they must
select a test, but only one test; How can I force tem to: a. choose a test,
and b. select only one test? I am a novice at programming so please take me
step by step. Thanks!!

How do I force only one entry in a range?
 

One option is to have a single cell with Data Validation which provides a
list of your tests. This will only allow the selection of one item and you
could test to see if there was an entry.

If this approach is exceptable, please let me know and I'll explain further
if required.

How is your data currently organised i.e. how is a test selected?

"cfspahn24" wrote:

I have to have te user select a test they performed on a patient, they must
select a test, but only one test; How can I force tem to: a. choose a test,
and b. select only one test? I am a novice at programming so please take me
step by step. Thanks!!

How do I force only one entry in a range?
 

This sounds like what I want. Please explain further. (I need some "hand
holding" for this). Thanks for your response.

"Toppers" wrote:

One option is to have a single cell with Data Validation which provides a
list of your tests. This will only allow the selection of one item and you
could test to see if there was an entry.

If this approach is exceptable, please let me know and I'll explain further
if required.

How is your data currently organised i.e. how is a test selected?

"cfspahn24" wrote:

I have to have te user select a test they performed on a patient, they must
select a test, but only one test; How can I force tem to: a. choose a test,
and b. select only one test? I am a novice at programming so please take me
step by step. Thanks!!

How do I force only one entry in a range?
 

To make your drop down with a list of choices:

Make a list of the items you will allow to be chosen.

Under Data Validation Settings Click the down arrow in Allow select
List click in Source box take your cursor and high-light your list on
the sheet OK.

Now only those items will be allowed to be chosen or entered in the cell.
However, one can copy and paste anything in the cell and that blows the
validation away.

If you don't want your list on the "working" sheet you can put it on an
adjacent sheet. But now you will have to name it to use as the list. So
select the list and in the name box type in the name, "MyList" for example
without the quotes.

Now when you set up your validation as above, when you click in the Source
box you enter =MyList then click OK.

HTH
Regards,
Howard

"cfspahn24" wrote in message
...
I have to have te user select a test they performed on a patient, they must
select a test, but only one test; How can I force tem to: a. choose a
test,
and b. select only one test? I am a novice at programming so please take
me
step by step. Thanks!!

How do I force only one entry in a range?
 

Howard has replied on my behalf! so I hope you are able to progress

"L. Howard Kittle" wrote:

To make your drop down with a list of choices:

Make a list of the items you will allow to be chosen.

Under Data Validation Settings Click the down arrow in Allow select
List click in Source box take your cursor and high-light your list on
the sheet OK.

Now only those items will be allowed to be chosen or entered in the cell.
However, one can copy and paste anything in the cell and that blows the
validation away.

If you don't want your list on the "working" sheet you can put it on an
adjacent sheet. But now you will have to name it to use as the list. So
select the list and in the name box type in the name, "MyList" for example
without the quotes.

Now when you set up your validation as above, when you click in the Source
box you enter =MyList then click OK.

HTH
Regards,
Howard

"cfspahn24" wrote in message
...
I have to have te user select a test they performed on a patient, they must
select a test, but only one test; How can I force tem to: a. choose a
test,
and b. select only one test? I am a novice at programming so please take
me
step by step. Thanks!!