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

**a.mack123** · 08-12-2010, 11:50 AM

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

Please Login or Register  to view this content.

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

**a.mack123** · 08-12-2010, 11:50 AM

If its relevant in any way I though I should mention the sheet's name is Today

**shg** · 08-12-2010, 05:07 PM

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.

**a.mack123** · 08-13-2010, 11:02 PM

When im in the macro coding section, the line Range(F4).. is highlighted in yellow and when i place the cursor over the f4 it brings up at note saying F4 = empty?

I have attached the workbook becasue I am unsure of how to fix it.

Cheers

**royUK** · 08-14-2010, 03:03 AM

You need speech marks around the range references

Please Login or Register  to view this content.

Also, please use Code Tags in future

**a.mack123** · 08-14-2010, 03:12 AM

thankyou very much that did the trick

**royUK** · 08-14-2010, 03:16 AM

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