Reply to message Excel 97

[adrian]

Would someone be able to relpy to my recent question below i really need
to know this asap...very important... here is the question again, or
even give me some url's or infor where to fine out how to do this.

Question>

I am trying to format a column so that it keeps track of computer
hardware mac addresses.

-Each cell must be limited to 17 characters only.
-Cells must have 5 visible permanent colons so that users may only
enter the remaining 12 letters/numbers.
-cells must be restricted to entry of letters and numbers (no special
characters).
-users must be presented with an error message if they try to leave the
cell without entering 12 letters/numbers.
-column must not accept duplicate mac addresses.


Can anyone give me some direction on how to do this?

thanks guys/ladies



------------------------------------------------


-- View and post Excel related usenet messages directly from http://www.ExcelTip.com/forum
at http://www.ExcelTip.com/
------------------------------------------------

 

[Andy Brown]

You can restrict input with Data Validation (tho' NB not bulletproof, can be
over-ridden with copy and paste) - lots of info here
http://www.contextures.com/xlDataVal01.html

Another option might be event code to check immediately after input - lots
more info here http://www.mvps.org/dmcritchie/excel/event.htm

Rgds,
Andy