Using macro recorder increment cell by one?

[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

 

[Gary''s Student]

Select a cell and run:

Sub BumpIt()
With ActiveCell
..Value = .Value + 1
End With
End Sub

 

[Gord Dibben]

Stick a Spin Button on your sheet.

Control Toolbox or Forms Toolbar.


Gord Dibben MS Excel MVP

 

[Student2]

Thanks - easy to set up and works great!

Stick a Spin Button on your sheet.

Control Toolbox or Forms Toolbar.


Gord Dibben MS Excel MVP

 

[Student2]

What is the procedure for entering this language and being able to run it?
Sorry, this is new territory for me.