Opening Form Via Button From Worksheet Performs Differently To Running Through VBA Editor

[Brumbot]

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.

[Fettertiger]

Hi Brumbot,

have a look at the macros where it says:

Please Login or Register  to view this content.

You are missing the "." (Dot) before the range. As soon as I add the dots everything works fine


Let me know if this fixes your issue

Theo