I hope you enjoyed this tutorial 😃 If you did please give it a LIKE... and don’t forget to SUBSCRIBE for even more content! For More 👉 essentialexceluk.com/blogs/tutorials
Thank you dear this is really the easiest way to about user form. I just want to know if code instead of unload is there any way to clear form after saving to enter another entry.
If I have a questionnaire with 50 questions. Each question has 5 answers to check, selected only one answer. So while the person clicks on the check box answer, how the selected answers can populate in another hidden sheet, same workbook and be counted. I did long time ago in 2002, but I lost and I can't remember how I did. The hidden sheet should be like that. Q1 on the a2 column, and the answer would be on the b2=1(1 means answer 1 was selected), b3=5(selected answer 5). Then Q2(Question 2) would be on the a4 with same pattern as described before. Then each responder returns the questionnaire via email. How I would combine all the 50 questionnaires via VBA or via query, etc? There are 17 people that responds to the questionnaire. I could do in google forms, but I want to do in VBA to populate the answers and then combine all the questionnaires to another sheet to have all the counts, percentage, etc.
I hope you enjoyed this tutorial 😃 If you did please give it a LIKE... and don’t forget to SUBSCRIBE for even more content!
For More 👉 essentialexceluk.com/blogs/tutorials
Thank you for the simple introduction to VBA!
Thank you dear this is really the easiest way to about user form.
I just want to know if code instead of unload is there any way to clear form after saving to enter another entry.
Can multiple user use this at same time?
one cannot see your spreadsheet. fix it
Another excell sheet open means user form log in page automatically log out...how I short out this issue
On my question below I meant to say how to combine in VBA and/or in power query, etc the questionnaires's answers. The responders are 17,0000.
👏👏👏
If I have a questionnaire with 50 questions. Each question has 5 answers to check, selected only one answer. So while the person clicks on the check box answer, how the selected answers can populate in another hidden sheet, same workbook and be counted. I did long time ago in 2002, but I lost and I can't remember how I did. The hidden sheet should be like that. Q1 on the a2 column, and the answer would be on the b2=1(1 means answer 1 was selected), b3=5(selected answer 5). Then Q2(Question 2) would be on the a4 with same pattern as described before. Then each responder returns the questionnaire via email. How I would combine all the 50 questionnaires via VBA or via query, etc? There are 17 people that responds to the questionnaire. I could do in google forms, but I want to do in VBA to populate the answers and then combine all the questionnaires to another sheet to have all the counts, percentage, etc.