Want to use VBA to format and validate cell content

Hi all,

My request is similar to this one: http://www.excelforum.com/excel-form...l-content.html

I'm looking to create data validation as well as format the input for a cell, according to these stipulations:
-The data will be formatted as XXX-######
-Any of the first 3 characters before the dash are either alpha or numeric
-The last 6 characters after the dash are always numeric
-The user should be able to enter or not enter the dash, (if not then the code should insert it for them)
-If there are not exactly 9 characters (or 10 if the dash is present) or if there are special characters or if the last 6 characters contain alpha, a warning box should follow.

I'm not familiar enough with VBA syntax to code this myself.

Thanks in advance for your assistance.

Wow thanks for the quick reply!

Code works great with initial testing (so far i've added to the length check to test for values that are too short as well). I'm out until next week for the holiday, and will test further and report back with any questions/and mark it closed then.

Again, thank you very much for your time!

Ok, so I have an issue:

If the user enters data into the target cell, then deletes the data, then re-enters data that should cause an action, the action no longer will occur. I think that this might have to do with the errorflag status not getting reset, but I'm not sure and I've been unable to get it working. Here's my modified code thus far (I've changed the target range and changed the length check as mentioned).

Please Login or Register  to view this content.

Thanks again.