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

Rather than add those 2 button via code do it at design stage. Code against the events as normal.
Then when Initialising the userform re-position the 2 buttons.

You could set the ControlSource property of the textbox, although this does not allow for the Cancelling of changed values.

So maybe better to load the textbox as you create it. And code in the OK click event would loop through the controls you added and output the text to the appropriate cell.

Use something like this.

Please Login or Register  to view this content.