• 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.

Survey form with excel VBA

Hi,

Would you be specific that which type of survey you are looking for as google forms are great supplement for the same.

So sorry for late reply. I can't log in because forgot my password and which email i'm using for this account. LOL

Attached is an example. I want to create similar like that in excel. But more useful like able to do calculation for every answer so that i can make summary for the result.

Is there any idea how to make my desire become reality?
 

Attachments

  • Training Evaluation Form.docx
    46.2 KB · Views: 25
First cheek @ googleforms
hi, already look at googleform, but it's not what I want.
Yes it's easy to create survey and put the result in googlesheet.

But for my case, we not doing it online. Usually we give hard-copy to participant who attend our class. So after we collect all the form, we manually insert the survey in excel. So I would like to create the form in excel and just key in the survey in that form, and (maybe) one click of button can bring all data from that form to some table. Once the table is filled with data, I can use it to do some statistic and so on.

Here is example attached. The Over-time form i created.
 

Attachments

  • over-time form.zip
    829.9 KB · Views: 38
Back
Top