First of all, I don't have any idea what I am doing. Just found this thread on the internet hoping to figure this out. So far, not happening! I have 80 cells that I will be needing this for. My question is, 1) is there a different way in which I can tally each cell when I click it; and 2) Do I have to make the same macro for each cell changing the sub and the range and how would I associate the button with the cell selected without making multiple buttons? 3) Is there an easier way to do this?
Hope I am not confusing you.
Sub tally()
Range("I6").Value = Range("I6").Value + 1
End Sub
Sub button_maker()
Dim r As Range
Set r = Selection
ActiveSheet.Buttons.Add(94.5, 75.75, 51, 27.75).Select
Selection.OnAction = "tally"
ActiveSheet.Shapes(1).Select
Selection.Characters.Text = "Bump"
r.Select
End Sub
Thank you in advance for any help you may be able to give.
Bookmarks