COUNTING

ROAST · May 22nd, 2002, 03:16 PM

ON MY SPREADSHEET I HAVE PLACED A BUTTON CALLED ADD.
EACH TIME THE BUTTON IS PRESSED I WANT TO ADD 1 TO THE CELL F2.
PLEASE COULD SOMEONE TELL ME HOW I DO IT?
THANKS

lenze · May 22nd, 2002, 03:20 PM

Assign this code to your button.

Sub Button1_Click()
Range("F2").Value = Range("F2").Value + 1
End Sub

ROAST · May 22nd, 2002, 03:23 PM

THANKS

Mark W. · May 22nd, 2002, 04:34 PM

Also, you could have placed a Spinner (from the Forms toolbar) on your worksheet and configured it (by right clicking on the object and choosing Format Control...) to increment and decrement by 1.

[ This Message was edited by: Mark W. on 2002-05-22 15:35 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 22nd, 2002, 03:16 PM	#1
ROAST New Member Join Date: Apr 2002 Posts: 21	ON MY SPREADSHEET I HAVE PLACED A BUTTON CALLED ADD. EACH TIME THE BUTTON IS PRESSED I WANT TO ADD 1 TO THE CELL F2. PLEASE COULD SOMEONE TELL ME HOW I DO IT? THANKS

May 22nd, 2002, 03:20 PM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	Assign this code to your button. Sub Button1_Click() Range("F2").Value = Range("F2").Value + 1 End Sub

May 22nd, 2002, 03:23 PM	#3
ROAST New Member Join Date: Apr 2002 Posts: 21	THANKS

May 22nd, 2002, 04:34 PM	#4
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Also, you could have placed a Spinner (from the Forms toolbar) on your worksheet and configured it (by right clicking on the object and choosing Format Control...) to increment and decrement by 1. [ This Message was edited by: Mark W. on 2002-05-22 15:35 ]