Using data from a dynamic vba form in Excel
Posted on 2013-01-16
I have created a dynamic form in Excel vba to loop through a column and add checkboxes with the column items as captions on the form.
My goal is to use the form as a voting form where a user would check the boxes for the choices needed and click the submit button, then for each box checked, the column in Excel would be updated +1 to count total votes for a selection.
I cannot get the submit and count of votes for checked boxes to work at all. Any assistance provided would be greatly appreciated