Plz help with employees criteria

[mostafa hussien]

I need to construct vba for following
4 teams, each team 4 members
Each member with 4 criteria ( does he wear safety helmet? ) In form of questions with yes or no answers
This entry for all teams to be daily
Then collect compliance statistics per period for selected employees

I know excel, but vba none

I think a sheet with headers in first row (team, member, question, answer, date) then a button when clicked enters the data into another sheet, then a 3rd sheet that retrieve statistics based on headers (like when selecting a certain member for certain period of time, it calculates yeses divided by days per selected criteria)

Any help? Plz

[#2]

You should be able to get the userform working by looking at this userform example file (See attachment) I created a while back.  It describes how to make a userform with multiple screenshots, how to link a macro that launches the userform to a shape and then use the userform to collect data and put it one a data collection worksheet.  Once you have this price you can simply create the statistics page based on the data on the data collection sheet.