I am setting up a purchase order form from a template. I would like the
purchase order number to be sequential and automatic each time I acces the
form to issue a purchase order. Is ther a way to do this??

Hi,
Look into Mcgimpsey web it has the answer

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

if this helps please click yes, thanks

"Mike Riley" wrote:

I am setting up a purchase order form from a template. I would like the
purchase order number to be sequential and automatic each time I acces the
form to issue a purchase order. Is ther a way to do this??

Mike,
Here's a simple VBA solution.
http://www.mrexcel.com/archive/VBA/29143.html

If you're new to VBA check out these links.
http://www.mvps.org/dmcritchie/excel/getstarted.htm
http://www.anthony-vba.kefra.com/vba...and_Procedures
http://pubs.logicalexpressions.com/p...cle.asp?ID=302

Hope this helps.
Dave

"Mike Riley" <Mike wrote in message
...
I am setting up a purchase order form from a template. I would like the
purchase order number to be sequential and automatic each time I acces the
form to issue a purchase order. Is ther a way to do this??