Restricting values of cell to the ones on scrolldown list exclusiv

[Jorge E. Jaramillo]

Hi

I know how to make a scrolldown list so that people can choose options from
it to enter into a cell, but the problem is that if by accident someone would
type anything while on that cell, the cell would accept such entry. Even
worse, the connection to the scrolldwon list would be lost.

Is there a way to restrict such action? I mean that the cell would only
allow the values from the scrolldown list and nothing else?

Thanks

Jorge E Jaramillo

 

[David Heaton]

Hi

I know how to make a scrolldown list so that people can choose options from
it to enter into a cell, but the problem is that if by accident someone would
type anything while on that cell, the cell would accept such entry. Even
worse, the connection to the scrolldwon list would be lost.

Is there a way to restrict such action? I mean that the cell would only
allow the values from the scrolldown list and nothing else?

Thanks

Jorge E Jaramillo

Jorge,

Use a data validation list, linked to the list of available values
somewhere else on your sheet.
This restricts the values to those on the list.

Regards

David

 

[Jorge E. Jaramillo]

Sound clever. I'll try it

Thanks
Jorge E