How do I create a button to enter a number in a cell and then tab/enter to next cell

I need to create a button with a macro that every time you click on it will enter a number 1 into a cell and then tab to the next cell. When you click on it again it will enter a 1 in the new cell and then tab to the next one. And so on.....

I'm assuming you're running Excel 2007. Let me know if you're not.
Insert a button from the developer tab anywhere you would like.
Go to "Macros", which is on the left hand side of the ribbon on the develop tab.
Type in a name and click "Create". I'll use "ButtonClick".
You'll now see a module appear that has two lines: Sub ButtonClick() and End Sub.
Place your cursor in between the two lines and type the following:

Please Login or Register  to view this content.

Go back to Excel and right-click the button and select Assign Macro. Select the macro you just wrote and click OK.

Great, it works.

Thanks