User Form and getting data into spreadsheet

I am new to UserForms and I am trying to create a user form for data entry. I have created my form with 9 text boxes to enter into. Can you format these text boxes so when data is entered into them it is formatted as accounting? Also how can I get the data from the form to my spreadsheet into the next blank row?

Do to our Internet policy at my work I cannot download these files.

I don't know I will try.