msgbox = Input mask(user defined)

[Trevor]

I would like to allow the user to create the inputmask for [text1] but also I would like the custom msgbox that handles incorrect input to match the text formatting of the input mask ie: if the input mask is aaa## the message box would then display input must be in the format of abc12
I can change the input mask w/ dlookup but how to have the mesgbox match the inputmask in a user friendly mannor? my guess would be intstr([text1]) but that I think would only return true or false.

Thanks for helping

[ben.oates]

You can use bits of this code to check for alphanumeric characters in the input: http://www.freevbcode.com/ShowCode.asp?ID=6411

[Trevor]

Thanks,