Hello
I want to create a spreadsheet to manage a point system for 300 children. They all start with 1000 points. They lose points for certain behaviour and they get points for others - and there is no pattern. I have a POINTS column A, a NAME column B and a DATE column C. I'd like to click on the value in the POINTS column, next to a specific name and, by clicking on a command button, increase or decrease the value in the POINT cell by various increments (+5, +10, +2 or -1, -2, -3, -5, -10). Then, I'd like that day's date to appear in the DATE column.
With so many children, it must be as easy as possible to give- or deduct points.
I know how to increase/decrease the value of a specific cell using a command button, but I can't figure out what the VBA code must say to do the same thing in any cell, at random times - and how to automate the appearance of that day's date.
Is it possible? Can someone help?
I want to create a spreadsheet to manage a point system for 300 children. They all start with 1000 points. They lose points for certain behaviour and they get points for others - and there is no pattern. I have a POINTS column A, a NAME column B and a DATE column C. I'd like to click on the value in the POINTS column, next to a specific name and, by clicking on a command button, increase or decrease the value in the POINT cell by various increments (+5, +10, +2 or -1, -2, -3, -5, -10). Then, I'd like that day's date to appear in the DATE column.
With so many children, it must be as easy as possible to give- or deduct points.
I know how to increase/decrease the value of a specific cell using a command button, but I can't figure out what the VBA code must say to do the same thing in any cell, at random times - and how to automate the appearance of that day's date.
Is it possible? Can someone help?