the format you show has 14 characters and 4 of them are not numerals. So
restricitng it to 12 numerals only would be a little frustrating for your
users.

the obvious answer is to use the change event (or keydown/up/press events)
to check every character entered and reacting to it. The change event fires
on every key stroke (as do the others).

the exit event would make the check after the fact. I gave an example of
that.

--
Regards,
Tom Ogilvy





"Amber_D_Laws"
wrote in message
news:Amber_D_Laws.22x15n_1139410504.8372@excelforu m-nospam.com...

Wow....that kind of stired up a bee hive.

My users will not have to enter international numbers. In fact all of
our clients are from the US within a 3-4 state region. So coding for
disperate forms of country/area codes isn't really a consideration in
this instance, but thanks for the heads-up.:)

The format I want them to use is *(###) ###-####*

So, as someone suggested, a custom format is easily accomplished, and
restricting the text box to no more than 12 characters is also easy.
What I don't know how to do is to limit what the user puts into the
text box to only *numerials*, and how to restrict them to using no
*less* than 12 characters.

Keep the idea coming, I am really learning alot from the discussion.

Regards,
Amber


--
Amber_D_Laws
------------------------------------------------------------------------
Amber_D_Laws's Profile:
http://www.excelforum.com/member.php...o&userid=30012
View this thread: http://www.excelforum.com/showthread...hreadid=509591