Array help.

[Jay]

Hi Guys,

Here's what I wanted to do using an array.

listed the ff column numbers (7, 11, 15, 19, 23, 27, 37, 35, 39, 43, 47,
51, 55, 59, 63) in an array and as I click in any part of the cell and press
ok it'll look in that series of value in the array and prompt "invalid
column" if its not found and returns "found" in the activecell if it has
found.

Thanks,
Jay

 

[Joel]

You can't trigger an event until data is entered into the cell. then you can
display a message "Data Entered in Invalid cell". You can also perform an
UNDO to return the data to its previous value.

Instead you may want to protect the sheet and then allow users to enter data
in specific ranges (columns).