Using macro recorder increment cell by one?
 

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

Using macro recorder increment cell by one?
 

Select a cell and run:

Sub BumpIt()
With ActiveCell
..Value = .Value + 1
End With
End Sub
--
Gary''s Student - gsnu200841


"Student2" wrote:

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

Using macro recorder increment cell by one?
 

Stick a Spin Button on your sheet.

Control Toolbox or Forms Toolbar.


Gord Dibben MS Excel MVP

On Tue, 24 Mar 2009 14:10:06 -0700, Student2
wrote:

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

Using macro recorder increment cell by one?
 

Thanks - easy to set up and works great!

"Gord Dibben" wrote:

Stick a Spin Button on your sheet.

Control Toolbox or Forms Toolbar.


Gord Dibben MS Excel MVP

On Tue, 24 Mar 2009 14:10:06 -0700, Student2
wrote:

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

Using macro recorder increment cell by one?
 

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

"Gary''s Student" wrote:

Select a cell and run:

Sub BumpIt()
With ActiveCell
.Value = .Value + 1
End With
End Sub
--
Gary''s Student - gsnu200841


"Student2" wrote:

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