Hello,
I have a Userform that contains 3 option groups and a submit button. The first option group has three items, the second has two items, and the third has two items.
I want to enforce completion of all groups, and was thinking to do so by adding a counter to the form. When the user selects one item from the first group it is incremented by one, and so on for groups 2 and 3. Of course I would have to add some logic in the case that someone selects item1 from a group, then changes their mind and selects another item. Hitting the Submit button will compare the sum of the counter to the expected number of selections (in this case, 3), and either complete the submission of the data or kick out a message box, informing the user of their error and re-setting the form.
....any suggestions about how to approach this? The counter issue, I mean...
Thanks in advance.
I have a Userform that contains 3 option groups and a submit button. The first option group has three items, the second has two items, and the third has two items.
I want to enforce completion of all groups, and was thinking to do so by adding a counter to the form. When the user selects one item from the first group it is incremented by one, and so on for groups 2 and 3. Of course I would have to add some logic in the case that someone selects item1 from a group, then changes their mind and selects another item. Hitting the Submit button will compare the sum of the counter to the expected number of selections (in this case, 3), and either complete the submission of the data or kick out a message box, informing the user of their error and re-setting the form.
....any suggestions about how to approach this? The counter issue, I mean...
Thanks in advance.