Using a Form Button to add 1 to a cell each time it is clicked

Hi all,

Ill start with the circumstance. I have a spreadsheet where there are multiple form buttons.
For this example Ill use one because I beleive I will be able to extrapolate the formula to the others.

I have one form button named "Small Latte", when it is clicked I would like to add one to the value of cell F4

Currently I am using the formula

Sub LatteSmladd1()

Range(F4).Select
Selection.Value = Selection.Value + 1
Beep

End Sub

I get the error: Run-time error '1004': Method 'Range' of object '_Global' failed

I think its telling me that its empty, F4 has a value of 0 and I want it to stay at 0 until the button is clicked

Is there anything I can do to get this working?

I would greatly appreciate any help.

Cheers

The code should work fine, though the selection is not necessary; post a workbook if you can, after editing your post to add CODE tags.

You need speech marks around the range references

Sub LatteSmladd1()
    Range("f4").Value = Range("f4").Value + 1
    Beep
 End Sub

Also, please use Code Tags in future

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save