Execute code from auto generated buttons in a userform

I soon don't have any hair left, so please help me out...

I have 3 Regions with a number (different between regions) of companies. Via a userform i would like the user to state how many employees each company holds and save this information back to the spreadsheet.

The attached file descibes my problem.

1. Via a ComboBox Region A, B or C is choosen.

2. By clicking the Indata-button the userform isshown. Since each region have different number of companies (cells F33:G54), the userform will have different number of Labels and TextBoxes depending on which region that is choosen.

When the userform initiates, cells C15:C17, are used to decide what information will be shown in the userform. The Cancel-button and Save-button are also created when the userform initiates.

By filling in number of employees and clicking the Save-button, the number of employees should be written to cell H34:H54.

By clicking the Cancel-button, the userform should just be unloaded.


I can not get this to work!

1. How do I get the Cancel-button and Save-button to work? I can not get them to execute any code.
2. How do I get the information in the textboxes (number of employees) to be written into the worksheet.

Any ideas on how to solve this are more then wellcome!
/Fredrik