excel userform textbox validation

Hi all,

Need your help with textbox validation.

I need the validation for the following:

Textbox will accept this ###### - 6 digit numbers and ######-## = 6 digit number followed by "-" and another 2 digit number.

Is this possible?

Thanks!

Thanks! working perfectly.

Different situations might need different approaches so an alternative that is proactive rather than reactive...

Please Login or Register  to view this content.

It also adds the separating '-' automatically.