User Form textbox formatting
 

Dear VBA experts,

I am setting up a userform with textboxes to gather
information such as name, address, home telephone number,
zip code, and social security number. In excel, there is
the formatting where you can have the user type in the
phone number numerals and excel would place in the ()
around the area code. Is it possible in the user form to
format the telephone number and zip code and social
security number with that special formatting when the user
types that info in?
In addition, border style creates a border around the
entire textbox. Is it possible to have just the bottom
border instead? Thanks.

Neal