How do I format a button to increment up or down by 1?

[mikedunbar]

Hello-
I hope this isn't too stupid. I'm trying to make an order sheet for a diner. I want there to be a button that you can push (on a handheld pda) inside the spreadsheet which will increment and then output a number by 1. I found the way to put a button in, but I can't get it do do anything when I preview it, or preview it in a browser. I hope someone can help.
thanks in advance, Mikedunbar.

[acknak]

You can configure a "spin button" control to increment (or decrement) a cell value, using nothing other than the standard Calc menus and settings, but you can't make a plain button that does that without using a bit of macro programming. The button would be linked to your little program, so that when you click on the button, your code is called, which then updates some particular cell's value.

Here's a sample spin button:

[mikedunbar]

that's exactly the ticket. Thank you very much.

[TheGurkha]

If this has answered your question please go to your first post and use the Edit button, and add [Solved] to the start of the title. You can use the green tick icon at the same time if you like.