Hi All,
Iam new to VBA and have run into a few problems when trying to write a small code.
Baisically what Iam trying to do is when a user click's on a button, a macro adds the value of 1 to whatever number is in the cell. This is what I have come upwith that seems to work:
Range("u43").Select
ActiveCell.Value = ActiveCell.Text + 1
MsgBox "You have added 1 to your score"
What I want to do though is make it date dependant so for example when a user clicks the button to add 1, it adds it to a different cell for each day of the month.
I have used the =TODAY() and the =DAY(S37) to display the day of the month as I thought I could get the macro to read this cell with the day of the month so it knows which cell to add it to.
I cannot seem to get any further than this and would really appricate it if someone could assit me?
Thanks In Advance
Marc
Iam new to VBA and have run into a few problems when trying to write a small code.
Baisically what Iam trying to do is when a user click's on a button, a macro adds the value of 1 to whatever number is in the cell. This is what I have come upwith that seems to work:
Range("u43").Select
ActiveCell.Value = ActiveCell.Text + 1
MsgBox "You have added 1 to your score"
What I want to do though is make it date dependant so for example when a user clicks the button to add 1, it adds it to a different cell for each day of the month.
I have used the =TODAY() and the =DAY(S37) to display the day of the month as I thought I could get the macro to read this cell with the day of the month so it knows which cell to add it to.
I cannot seem to get any further than this and would really appricate it if someone could assit me?
Thanks In Advance
Marc