Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using a command button to add
I would like to click on a command button - it would then add 1 to a
predetermined cell |
#2
|
|||
|
|||
Using a command button to add
Which bit do you want, the add bit
With Range("H10") .Value = .Value + 1 End With or add the button. Drag it off the Forms toolbar and assign a macro with the above code -- HTH RP (remove nothere from the email address if mailing direct) "Chance" wrote in message ... I would like to click on a command button - it would then add 1 to a predetermined cell |
#3
|
|||
|
|||
Using a command button to add
Hi
You do not say at what stage this cell will be determined? Is it always the same cell, is it the active cell, or do you want to establish which cell is to be acted on? -- ve_2nd_at. Randburg, Gauteng, South Africa "Chance" wrote: I would like to click on a command button - it would then add 1 to a predetermined cell |
#4
|
|||
|
|||
Using a command button to add
Always the same cell
"Kassie" wrote: Hi You do not say at what stage this cell will be determined? Is it always the same cell, is it the active cell, or do you want to establish which cell is to be acted on? -- ve_2nd_at. Randburg, Gauteng, South Africa "Chance" wrote: I would like to click on a command button - it would then add 1 to a predetermined cell |
#5
|
|||
|
|||
Using a command button to add
I wanted the code.
Thank you "Bob Phillips" wrote: Which bit do you want, the add bit With Range("H10") .Value = .Value + 1 End With or add the button. Drag it off the Forms toolbar and assign a macro with the above code -- HTH RP (remove nothere from the email address if mailing direct) "Chance" wrote in message ... I would like to click on a command button - it would then add 1 to a predetermined cell |
#6
|
|||
|
|||
Using a command button to add
You need to have a blank cell to the right of the number you are adding to, then select that blank cell hit the combined button assigned to macro below. Sub PlusOne() ActiveCell.FormulaR1C1 = "=RC[-1]+1" End Sub -- comotoman ------------------------------------------------------------------------ comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292 View this thread: http://www.excelforum.com/showthread...hreadid=478309 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|