Hi Everyone,

I am very new in VBA coding and I had managed to construct a userform with comboboxes and textboxes. What I am stuck with now is how to transfer the data entered in the userform to the specific worksheet with each comboboxes and textboxes corresponded to specific cells.

Heres what I want:

All data should be transferred to a worksheet called "Field Book" when a button clicked

Combobox4 to E4
TextBox2 to E5
TextBox3 and texbox 4 concatenated to E6

About 20 more comboboxes and textboxes which need to be entered and transferred until the last cell which is "E43"

Could someone help me out on the perfect code that will do the trick.