Phone validator for textbox

  • Re: Phone validator for textbox


    jonny,


    I assume you're looking for validation similar to that carried out automatically in Access; you will need to build some code to do this in Excel.


    First off, you will need to decide how you want your users to originally enter the data in the text box. You could, for instance, allow them to enter a complete, unbroken string of numbers and then add the other characters yourself, or you could force them to enter the data in the exact format you want to output.


    If you let us know which (or what other option) you would like, I'm sure we'll be able to help.


    Regards,
    Batman.

    [COLOR="Purple"]Regards,[/COLOR]
    [COLOR="Purple"]Batman.[/COLOR]

  • Re: Phone validator for textbox


    Ian,


    I suspect you should be able to shorten the code in your form to validate the entry to

    Code
    If Not sText Like "+###-(#)-#######" Then


    Regards,
    Batman.

    [COLOR="Purple"]Regards,[/COLOR]
    [COLOR="Purple"]Batman.[/COLOR]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!