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