Excel 2007 - VBA Coding
I have a userform that when the submit button is clicked dumps the data collected in the form onto a spreadsheet. Currently the checkboxes dump a "True/False" statement onto the spreadsheet. Userform has 24 checkboxes. I am wondering where/if I can have the "True/False" produce either a 1,0,-1 (number) based on the selection, rather then the "True/False." There are eight series of three checkboxes. Each series has a Yes-Checkbox, a No-Checkbox, a N/A checkbox. I'm thinking a Yes=1, No=-1, N/A=-1 from the overall count. (As in the question does not count as it doesn't apply.) The overall score is based on eight questions, or however many apply. (See attachment1 for Userform, this attachment also includes the VBA coding for the submit button on the userform)