Hi Guys,
I have a user form into which data can be entered and is populated on the next sheet.
The order ID is unique, is there way I can make the Order ID auto generated each time a record is entered instead of manually keying the number?
Hi Guys,
I have a user form into which data can be entered and is populated on the next sheet.
The order ID is unique, is there way I can make the Order ID auto generated each time a record is entered instead of manually keying the number?
Hi,
Yes just hold a variable cell on the worksheet somewhere that contains the ID#. Then as part of the record entry macro read the variable into a VBA variable, add 1 to it and save it back to Excel and use the increased value in the record entry.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Thanks for your response richard,
Please look at this link here - http://www.contextures.com/exceldata...pdateform.html,
I want the order Id to be auto-generated in this case. Can you please check if its working for this kind of a document.
Is there anyone who can help me please!
Hi,
Have you actually tried the general technique I gave you. It's the approach I always use for this sort of thing.
In addition any of Debra's suggestions on her Contextures site will undoubtedly work. Not sure what you mean by if IT is working in THIS kind of DOCUMENT. What is 'it' what is 'this' and what's the document.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks