Hello All
I'm having trouble coding a routine, probably due to my scan knowledge of VBA. This is the sort of thing:
Check the system date.
If it has changed since last time routine run then clear the contents of an accumulator and go on to the next sentence. If it hasn't then add user input time in minutes to the accumulator . On shuting the spreadsheet show a message "You have entered xxx minutes today" (where xxx is the contents of the accumulator).
Can anyone give me a hand with this?
Many thanks.
Elsie
I'm having trouble coding a routine, probably due to my scan knowledge of VBA. This is the sort of thing:
Check the system date.
If it has changed since last time routine run then clear the contents of an accumulator and go on to the next sentence. If it hasn't then add user input time in minutes to the accumulator . On shuting the spreadsheet show a message "You have entered xxx minutes today" (where xxx is the contents of the accumulator).
Can anyone give me a hand with this?
Many thanks.
Elsie