View Single Post
  #5   Report Post  
Chance
 
Posts: n/a
Default 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