Assign a number on a template

  • Thread starter Thread starter Val Leonard
  • Start date Start date
V

Val Leonard

I have created a template for a purchase order. I would
like to create a marco to assign the next purchase order
number automatically by clicking on a button. I can
create the button, but don't know how to create the macro
that will assign the PO number when the button on the
toolbar is clicked. Can anyone provide me with the steps
to create a marco for assigning the number in the
purchase order field cell.

Thanks
 
Val,

There's a bit to do to implement this reliably. You should probably keep a
list somewhere of the PO numbers as they're generated. A macro could look
at the latest number, generate the new one, and add an entry to the list.
 
Back
Top