UserForm Knowledge needed to make TextBoxes in both places as numbers

Hello again - more userform knowledges needed here. Please excuse my ignorance as I am very new to user forms.

Please see attached workbook. SHEET1 contains the macro to call the userform up and the form works just about the way I need it to other than (2) things which are related.

On the userform, I would like for the user to insert numbers within the sqaure footage textboxes. As the user tabs over or switches to another textbox, I would like for the format to read "#,###" with the comma seperator. Currently, if the user enters "####" , then "####" is what shows in the text box. I would like to see the comma seperator.

And also, when the data is inserted into the worksheet SHEET1, if it is entered as "####" then it views it as a text format. I need this format to be numbers (with comma seperator).

I am assuming that is an easy change, I just dont know where to do it. Any help would be greatly appreciated.



Side request: Is there an easy looping way to clean this up?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Or a loop:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

repeat for the others.