Using macro recorder increment cell by one?

  • Thread starter Thread starter Student2
  • Start date Start date
S

Student2

How do I increment a cell content by one using the Macro Recorder? That is 1
becomes 1+1=2, becomes 1+1+1=3. Each time the macro is run it increments the
existing value by 1.
Thanks
 
Select a cell and run:

Sub BumpIt()
With ActiveCell
..Value = .Value + 1
End With
End Sub
 
Stick a Spin Button on your sheet.

Control Toolbox or Forms Toolbar.


Gord Dibben MS Excel MVP
 
What is the procedure for entering this language and being able to run it?
Sorry, this is new territory for me.
 
Back
Top