I'm sure I'm missing something very basic here, but I have a simple problem.

I have a form that I wish the user to enter several fields into. Once they are done, they click the confirm button and it posts the information from the form into the 'Raw Data' worksheet.

When I am in the VBA Editor and I click the "Run Macro" button, it opens up my form, I can enter in all the information and confirm it and it will put all of the data exactly where I want it on the spreadsheet.
However, if I launch the form from a button I have put on the excel spreadsheet, and enter in the same information, it only pastes the date field, and nothing else. I have no idea why!

Can anyone help? Workbook attached.
Copy of Macro test No4 Plant.xlsm

Many thanks for your anticipated co-operation.