Select one checkbox and deselect all for each question
Dear Experts,
I not familiar with the VBA and I want to learn how to to this using checkbox instead option button. I also want to learn hoe to do macro for each question as well.
Attached my file here and hope expert can amend it for my reference.
Your help will be highly appreciated.
Thank you very much!!Book1.xlsx
It would be better to use ActiveX Optionbuttons and give each optionbutton question the same groupname. (Right-click on the optionbutton and select Properties and change Groupname. E.g. GroupApples or GroupQ1)
Then each group can only have one selected.
Optionbuttons, by design, are mutually INclusive, while checkboxes are mutually EXclusive. (You can search for those terms and read a lot on the subject.)
If you need help storing the answers after the questionnaire, then post back.
David
(*) Reputation points appreciated.
duplicate to http://www.excelforum.com/excel-prog...-question.html.
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks