Hi,

A quick introduction:

I am a high school teacher with no background in excel except my fascination for it.

I am trying to create a spreadsheet with analytics for my marking progress to help me churn through piles of exams and assignments.

So far I have created a button that removes 1 from the column of 'left to grade' and adds 1 to the column for 'completed'. I added a graph and it helps keeps me motivated during the hours and hours of marking.

I am trying to create a button that adds the current time to a cell and then moves on to add the current time to the next cell (.e.g click the button and the current times gets input in A2. Click button again and the current time gets added to B2 (column c will do a2-a1 to work out time spent on that paper). Click the button again and the current time gets added to A3, then B3, A4, B4 and so on).

I've tried figuring it out myself from basic tutorials and it seems there's a few possible ways it can be done (Using if then, elseif, ISBLANK and >0 (supposedly very easily), but I keep getting lots of errors.

Please don't laugh at me too hard, I have no background in coding and I assume the solution will probably be much more complex than I was anticipating.


Range("A2").Select
If ("A2") ISBLANK
ActiveCell.FormulaR1C1 = "=Now()"
ElseIf Selection.Offset(1, 0) Then
ActiveCell.FormulaR1C1 = "=Now()"
ElseIf Selection.Column < 2 Then
Selection.Offset(-1, -1).Select
ActiveCell.FormulaR1C1 = "=Now()"
ElseIf Selection.Offset(1, 0) Then
ActiveCell.FormulaR1C1 = "=Now()"
ElseIf Selection.Column < 2 Then
Selection.Offset(-1, -1).Select

End