View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mr-Re Man Mr-Re Man is offline
external usenet poster
 
Posts: 7
Default Button that will increment by 1

I am in the process of trying to create a spreadsheet that will have 5 buttons.
I want to position the button in cell B2, then when pressed it will
increment cell C2 by 1.

Then I need to repeat this 4 times so I'll have buttons and results in cells
B3 & C3, B4 & C4 etc.

I used this code from another thread, Selection.Value = Selection.Value + 1,
but it didn't work for 2 buttons, it incremented the same value whichever
button was pressed.