Robin Hernandez said:One more thing: Can I add buttons that just bump up whatever value is in a cell by +1? Like, if the number is 5, I hit the button and it jumps to 6?
Alright, let's say your number is sitting in A1. Right-click the Sheet tab at the bottom and hit
View Code. Just paste this Macro right here:
Code:
Sub plus()
Application.EnableCancelKey = xlDisabled
Application.ScreenUpdating = False
Range("A1") = Range("A1").Value + 1
End Sub
Head back to the Sheet. Drop a button next to your cell. Then Assign Macro
to it using the code you just pasted.
If you need to hit multiple cells on one sheet, do this:
Code:
Sub plus()
Application.EnableCancelKey = xlDisabled
Application.ScreenUpdating = False
Sheet2.Range("A1") = Sheet2.Range("A1").Value + 1
Sheet2.Range("A2") = Sheet2.Range("A2").Value + 1
Sheet2.Range("A3") = Sheet2.Range("A3").Value + 1
Sheet2.Range("A4") = Sheet2.Range("A4").Value + 1
Sheet2.Range("A5") = Sheet2.Range("A5").Value + 1
Sheet2.Range("A6") = Sheet2.Range("A6").Value + 1
End Sub