Hello,
I would like to create a data entry form for a table which would create multiple lines at once, depending on the ticked check boxes that would be in the form. The form would basically consist of 2 parts;
In the first part i would be able to input data in text boxes (e.g. for columns A, B and C) that will stay the same for all created rows of the form.
In the second part of the form there would be many check boxes, which i would be able to tick. (The corresponding text for the ticked boxes would display in different row, e.g. in column D.). These check boxes would be the variable part of the finishing table.
So each ticked check box in the form creates a new row in the table that consist (!) of the "constant" data inputed for the columns A, B and C and (2) the text for corresponding ticked check box in column D.
So the question is if it is possible to do this with VBA and how? ( i mean of course it's possible, the problem is that I just don't have enough knowledge yet to do it by myself, because I'm a total beginner i would need help only with the "coding" part, not with a form "editor".
Thanks in advance and kind regards
I would like to create a data entry form for a table which would create multiple lines at once, depending on the ticked check boxes that would be in the form. The form would basically consist of 2 parts;
In the first part i would be able to input data in text boxes (e.g. for columns A, B and C) that will stay the same for all created rows of the form.
In the second part of the form there would be many check boxes, which i would be able to tick. (The corresponding text for the ticked boxes would display in different row, e.g. in column D.). These check boxes would be the variable part of the finishing table.
So each ticked check box in the form creates a new row in the table that consist (!) of the "constant" data inputed for the columns A, B and C and (2) the text for corresponding ticked check box in column D.
So the question is if it is possible to do this with VBA and how? ( i mean of course it's possible, the problem is that I just don't have enough knowledge yet to do it by myself, because I'm a total beginner i would need help only with the "coding" part, not with a form "editor".
Thanks in advance and kind regards