Lock cells for combo box values only

[Daniel]

Hi,

I created an excel file where some of the cells are using "Validation" rules
that when the user selects the cell he can open a combobox that shows values
from a range declared earlier.

I want to limit the user to select only values from the list - currently he
can select from the list and write something else.

Also - how can I turn AutoComplete on these cells as well ?

Thanks,

[Tom Ogilvy]

You say your are using validation. The point of validation is that the user
is restricted to the list. However, unless the sheet is protected, the user
can past over the cell and remove the validation.

there is no autocomplete feature in Validation.

--
Regards,
Tom Ogilvy


"Daniel" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I created an excel file where some of the cells are using "Validation"
rules
> that when the user selects the cell he can open a combobox that shows
values
> from a range declared earlier.
>
> I want to limit the user to select only values from the list - currently
he
> can select from the list and write something else.
>
> Also - how can I turn AutoComplete on these cells as well ?
>
> Thanks,

[TJS]

Hi,

Make sure you have error alert turned on.

If combobox from the validation is in the same column and no empty rows in between, auto complete should work.(Could be a zero or a space value but not null)

[Daniel]

Can you suggst a better way to do that ?

"Tom Ogilvy" wrote:

> You say your are using validation. The point of validation is that the user
> is restricted to the list. However, unless the sheet is protected, the user
> can past over the cell and remove the validation.
>
> there is no autocomplete feature in Validation.
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Daniel" <[email protected]> wrote in message
> news:[email protected]...
> > Hi,
> >
> > I created an excel file where some of the cells are using "Validation"
> rules
> > that when the user selects the cell he can open a combobox that shows
> values
> > from a range declared earlier.
> >
> > I want to limit the user to select only values from the list - currently
> he
> > can select from the list and write something else.
> >
> > Also - how can I turn AutoComplete on these cells as well ?
> >
> > Thanks,
>
>
>

[TJS]

Hello again,

A better way would be having embedded combobox in the sheet. So you can control its behaviors.