User Form Textbox Formatted as Currency

You must add .Value at the end of

Please Login or Register  to view this content.

so it becomes

Please Login or Register  to view this content.

This will tell excel to enter it in the cell as a numeric value instead of text.
Do this with all the lines that require a number to be placed in the cell.
You can add .Text to the ones that require text to be placed in a cell.

Works perfectly thank you very much. I have just one more question referring to the serial number column. It has error saying it is a text field is really what I want because serial numbers aren't in need of calculations. Should I just ignore the error or is there a way to fix?

Thanks

You can do the same thing with that line of code as well, add the .Value to the end. Even if the Model/Serial numbers are alpha numeric, it will place them in the cell correctly and you wont get the error any more.

You're welcome. Thank you, same to you.