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,

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" wrote in message
...
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,

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" wrote in message
...
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,

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


--
TJS
------------------------------------------------------------------------
TJS's Profile: http://www.excelforum.com/member.php...o&userid=29583
View this thread: http://www.excelforum.com/showthread...hreadid=496454

:) Hello again,

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


--
TJS
------------------------------------------------------------------------
TJS's Profile: http://www.excelforum.com/member.php...o&userid=29583
View this thread: http://www.excelforum.com/showthread...hreadid=496454