• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macro Based Feedback Form

Ehtisham Ali

Ehtisham Ali

Member
Hi Guys,

I have designed a feedback form using Radio buttons. I have attached my file please review and suggest some code refinement.

Keeping in mind that adding more questions is difficult with existing code since for even 1 question it is required to add 5 new codes for responses.

Please feel free to ask me if the requirement is not clear enough.
 

Attachments

  • feedback form.xlsm
    59.2 KB · Views: 32
Rather than doing it all macro based, I might suggest using the basic Forms controls. You can still get a total value and 5-star system going on. Would be much easier to edit and I think it runs a little faster. I started to mock something up on Sheet2 of the workbook.

upload_2015-12-8_8-55-32.png

After you have it setup, you can hide the group boxes using this line of code:
Code: 
ActiveSheet.GroupBoxes.Visible = False
 

Attachments

  • feedback form LM.xlsm
    72.6 KB · Views: 30
You must log in or register to reply here.
Back
Top