eureka18
04-13-2011, 08:52 AM
Hello Everyone,
At this moment I am trying to make a form in excel with VBA. The form is meant to acquire information from several different people. However some people have more information than others and need more Textboxes and comboboxes. Therefore I would like to add new rows with textboxes and comboboxes automatically in the form.
I find it hard to explain what I mean therefore I added an example of the form in the attachment.
Here you see that at the moment Importing Country is filled in, another row with boxes appears. If in this new row importing country is filled in, another row should appear.
Is it possible to make this with vba and could somebody help me on this?
At this moment I am trying to make a form in excel with VBA. The form is meant to acquire information from several different people. However some people have more information than others and need more Textboxes and comboboxes. Therefore I would like to add new rows with textboxes and comboboxes automatically in the form.
I find it hard to explain what I mean therefore I added an example of the form in the attachment.
Here you see that at the moment Importing Country is filled in, another row with boxes appears. If in this new row importing country is filled in, another row should appear.
Is it possible to make this with vba and could somebody help me on this?