Assign a number on a template

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
 
E

Earl Kiosterud

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top