Hi,

I am creating a form on excell which will be filled by the account managers.

In one of colunms I want them to fill only a values that it in a list of
possibles values.

Examples:
Possible Valours: Monday, Tuesday, Wednesday, Thursday and Friday.

So they will not be allowed to type August.

And to help them, I want to create a list of the possible values which
automatically appears when they start to type.

Examples: If they type T, a list with Tuesday and Thursday would appear, so
they just have to choice the right one.

Is it possible to be done.

Thank you very much,

Vanessa Simmonds

Your best bet is probably to use Data - Validation - List. Fill in your
accepted values and then you will have an in cell drop down. You can specify
the alert if the user tries to enter a value not in the list...
--
HTH...

Jim Thomlinson


"Vanessa Simmonds" wrote:

Hi,

I am creating a form on excell which will be filled by the account managers.

In one of colunms I want them to fill only a values that it in a list of
possibles values.

Examples:
Possible Valours: Monday, Tuesday, Wednesday, Thursday and Friday.

So they will not be allowed to type August.

And to help them, I want to create a list of the possible values which
automatically appears when they start to type.

Examples: If they type T, a list with Tuesday and Thursday would appear, so
they just have to choice the right one.

Is it possible to be done.

Thank you very much,

Vanessa Simmonds