User form with 50 fields, how to reduce VBA code to transpose to sheet

[adhide]

Have searched the forums and being new at this (as it will soon be obvious) can located something of great assistance but am sure it is there somewhere.

I have created a, excel data capture user form which transposes the values of each form field to a corresponding sheet for calculations purposed and management of data (page protections etc). THe greatest concern is the number of inputs I need to create the code to push from the form to the sheet. (up to 50 odd pieces of information).

The issues in through learning this art in a simple way, is the code I have 'learned' is long, most likely used for small number of fields and wanted to understand if there is a better way to do this, by transposing the data from the form to cells in a report sheet - example of code in the attached images and hope I have expressed my self well enough to our experts.

[AliGW]

Please copy and paste the code to your post and add code tags around it (select the code and click on the # button).

Thread moved to the VBA section.