How can I generate a unique number each time a form is printed?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

homaxlinda - 17 Aug 2006 21:07 GMT

I have to create a form to use for inventory moves. I want the form to have
a unique control number each time it is printed. This way they can be signed
out and then signed in once the material handlers are done for the day. This
way I can keep track if one is not turned back in.

Reply to this Message

Niek Otten - 17 Aug 2006 21:52 GMT

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

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have to create a form to use for inventory moves. I want the form to have
| a unique control number each time it is printed. This way they can be signed
| out and then signed in once the material handlers are done for the day. This
| way I can keep track if one is not turned back in.

Reply to this Message