I have a User Form with several Control Buttons on it. This user Form has
about (50-60) Text Boxes & Combo Boxes on it. I would like to be able to fill
in the User Form and click on the Control Button and it updates the Workbook
automatically.

Control Button name is "Update_Enginering_Spec_8"
User Form Name is "UserForm1
Text Box name is "Location_4"
Combo Box name is "Address_41"
Workbook name is "Master_Engineering_Spec"
Workbook Sheet name is "Cover Sheet"

If someone would help me do the first one or two boxes, I can do the rest, I
am just not sure exactly how to do this. I would like to put each Control
Button in it's own Module to make it easy to trouble shoot later on if I need
to.

I need to use the Wookbook Name Reference, due to the fact that this User
Form Updates 3 Different Work Books. Each Work Book Update has it's own
Control Button. If I can get the first Workbook done the others are the same
just different Name and Cell Ref.

I think the code is something like this, but not su
Workbooks("Master_Engineering_Spec").Sheets("Cover Sheet").Range("D19") _
=UserForm1("Location_4")

Workbooks("Master_Engineering_Spec").Sheets("Cover Sheet").Range("D20") _
=UserForm1("Address_41")

Any help would be greatly appriecated.

Thanks