Create my own function/macro for validation

[vbace2]

How would I go about creating my own function or macro to perform complicated validation on a cell? Actually, maybe it isn't complicated validation. To try to be a little clearer, I know how to create macros/functions. Here is what I want to do...

In a column, I want the user to be able to enter 5 character codes. These codes should only be made up of characters and numbers. They can enter as many as they want (within Excel limits -- the most would probably only be around 10 or so). To enter more than one, I will probably have them enter a space or a comma in between each one. I will figure that out later. Anyway, after they tab out or hit enter, how can I have my validation macro/function run?

As for the macro/function...
I should be able to figure out how to create it, but if anyone has something that works already, I would appreciate the help.

Thanks to all.

[davesexcel]

don't know, what is the macro supposed to do??

[vbace2]

I have the macro created. It takes the cell contents, looks at every character to make sure that they are valid. If not, it should be a validation error. If there are extra spaces entered, the macro removes the extra spaces. It also converts any lower case letters to upper case. It then re-populates the cell with the cleaned up data.

[davesexcel]

Cool, I am not sure what the question, maybe it's how to activate the macro, is that it?

You said you have the macro created?

check out this string for an idea

http://www.excelforum.com/showthread.php?t=580224