B
bg18461
Is there a way to make a userform textbox auto format data while it
being entered. I.E.
The user is entering a telephone number, they enter the first 3 digits
then Parathesis in case these numbers (Area Code), then they enter th
next 3 digits, a (-) is inserted afterwards, then they enter the last
and tab to exit the field.
I guess you can call this active formatting, is there anyway. I ca
make the format change when the user exits the textbox, but I want i
to format it as they are typing
being entered. I.E.
The user is entering a telephone number, they enter the first 3 digits
then Parathesis in case these numbers (Area Code), then they enter th
next 3 digits, a (-) is inserted afterwards, then they enter the last
and tab to exit the field.
I guess you can call this active formatting, is there anyway. I ca
make the format change when the user exits the textbox, but I want i
to format it as they are typing