masked input telephone number?

B

bg18461

I am not too familiar with the Masked Edit Functions in Excel. I wan
to use a masked text box that when the user sets the focus to the box
inside will show something like (###) ###-####, so as they enter th
phone number it is actively taking the format shown above.

As it stands right now, when the focus is lost on that telephone entr
field, it will convert to the appropriate format. Users of the for
state it would be easier to have it format as they enter the numbe
into the field and I tend to agree. Any help would be appreciated
 
Top