Auto create new button and new invoice number excel 2007

You can use a combination of Excel formulas and formatting to create a new button and automatically generate a new invoice number in Excel 2007. Here's a step-by-step guide:

Step 1: Create a button

1. Go to the "Developer" tab in the ribbon (if you don't see it, go to "Office Button" > "Excel Options" > "Popular settings" and check the box next to "Show Developer tab in the Ribbon").
2. Click on the "Insert" button in the "Controls" group.
3. Select "Button" from the drop-down menu.
4. Draw the button on the worksheet where you want it to appear.
5. Right-click on the button and select "Assign Macro" (or press Alt+F11 to open the Visual Basic Editor).
6. In the Visual Basic Editor, create a new module by clicking "Insert" > "Module" (or press Alt+F11).
7. Paste the following code into the module:

   Sub CreateNewInvoice()
    Dim invoiceNumber As Integer
    invoiceNumber = WorksheetFunction.Max(Range("A:A")) + 1
    Range("A1").Value = "Invoice " & invoiceNumber
   End Sub

   This code will generate a new invoice number by finding the maximum value in column A and adding 1 to it.

Step 2: Format the button

1. Go back to the worksheet and select the button.
2. Right-click on the button and select "Format Control" (or press Alt+F11 to open the Visual Basic Editor).
3. In the "Format Control" dialog box, select the "Properties" tab.
4. In the "Caption" field, enter "Create New Invoice".
5. In the "On Click" field, select "Run Macro" and choose the "CreateNewInvoice" macro from the drop-down menu.

Step 3: Test the button

1. Click on the button to test it.
2. The button should generate a new invoice number and display it in cell A1.

Tips and Variations

• To make the button more user-friendly, you can add a label or a text box next to it to display the invoice number.
• You can also use a different column or range for the invoice number, just modify the code accordingly.
• If you want to save the invoice number in a specific format (e.g., "INV-001"), you can modify the code to include a formatting function, such as Text(invoiceNumber, "INV-000").
• You can also use this code as a starting point and modify it to fit your specific needs, such as generating a new invoice number based on a specific date or time.