Need a bit of help with an Excel project

wwfc_barmy_army · October 29th, 2004, 12:26 PM

Ok, well at college i have been set the task of making an invoice system that even a noob could use. The invoice system is for a chemist.

At the moment i have my main menu, a button on there links to customer details. Where the input box comes up like on the picture below, i made that come up with macros etc.

http://www.ashu56.dsl.pipex.com/Peter/excelchemist.png

What we have been asked to do also if to make it so the customer number is automatically put in each time an 'entry' is put in (so they don't have to put it in). I have no idea how to do this?

Can anyone help?

Cheers.

Pete.

BrianB · November 1st, 2004, 04:17 AM

Something like this :-

Code:

    Dim Database As Worksheet
    Dim LastRow As Long
    Dim CustomerNumber As Long
    '--------------------------
    Set Database = Worksheets("DataSheet")
    LastRow = Database.Range("A65536").End(xlup).Row
    CustomerNumber = Database.Cells(LastRow, 1).Value + 1

-----------------------
Regards BrianB
Most problems occur from starting at the wrong place.
Use a cup of coffee to make Windows run faster.
It is easy until you know how.