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

Attendance summation into points VBA based macro

D

dkunal89

New Member
Dear all,

I do not know how to code at all. I am currently looking for a ready made VBA based macro that can help manage my monthly attendance and calculate the total points received on maximum attendance. I am taking a class for under privilege children and want to incentivise them to attend. Wanted to make the process easy by adding a present or absent button. Assigning days to students and assigning a point for each class they attend. Is there something out there that I could use?

Regards,
KD
 
I can make this easier. If I already have an attendance sheet on Excel. i also know how to add a VBA button on excel. I want to know what code I can use so that is the button is clicked, 1 gets assigned to the cell that has been assinged to the current date. I can get on a call with someone to explain better. Not sure how easy it would be to respond to this question through the forum.
 
Do a google search on it. Without knowing your specific requirement, no one will be able to help you. You will have to download and try out different templates out there, to decide which one will meet your need.

One such template in below thread (template posted by Jeff Bedel). Though it counts number of days, you can easily add formula to calculate points earned. This template does not use vba code. But it's a good set up and can be customized to suite many needs.

http://chandoo.org/forum/threads/attendance-calendar-help.30988/#post-184422
 
I have tried multiple templates and I have been able to settle on one. I will further explain my requirement. If you have the patience then help me out, if not, I appreciate the effort.

Scenario:

I have about 50 children visiting me 6 days a week broken down into different batches in a day. All the students are bifurcated into batches, however, they might change their batch half way through the month. Now I have a template in which i manually need to enter 1 as present which would calculate at the end of 30 days the total number of turns attended. I would like to solve this using a button (toggle button from what i understand), so the children can press it when they come.

Current Limitation:

I have managed to learn how to add a toggle button to my sheet and also learnt how to assign 1 or 0 to it. The problem I am facing is that I have 30-31 days in a month and it would be impossible to program 30-31 toggle buttons every month for 50-100 students. If i could have 1 toggle button per name and program it to add 1 to the current date when clicked, it would be perfect.

Do you think you can help me with that?
 
Can you upload sample workbook that you have?

After reading through your post, I'd probably recommend another approach. As toggle isn't really ideal in this sort of situation.
 
You must log in or register to reply here.
Back
Top