PDA

View Full Version : Input restriction



sasa
12-27-2010, 02:53 AM
Hi there,
well, someone can help me about this topic ?
I need a simple macro that detected some cells on my sheet (eg. A1, C3, D4, F9), does not allow me to put there a determined string. ( eg "John".
May be it says : John is not allowed, try again
It will be a sort of input control.

Thanks in advance

Sasa

shrivallabha
12-27-2010, 06:34 AM
If you have a list of valid inputs then you can use Data >> Validation >> List.

sasa
12-28-2010, 01:47 PM
But, there is not a way to do it by a macro ?

Bob Phillips
12-28-2010, 02:06 PM
Why would you want to if you can avoid code?