Excel 2007 : VBA Help Needed to Create a Macro to create a Unique Number...

The workbook you attached has no code in it, so I'm not sure how it's getting sorted. Are you doing this manually, or is there code behind the sort? Also, I need a bit of information about what kind of format you need the system ID to have. Is it pure numeric? Do you want alpha characters as well? How many digits? Same number of digits every time?

The code in the attached workbook will generate a new ID number based on the greatest value it finds in the D column. If you are inserting a single ID number, position your cursor in the blank cell where you want to place the ID number, and run the macro NewID. If you want to generate more than one, select the cells in which you want to place the ID. CAUTION! This will place an incremented number in EVERY cell you select, so only select cells in the D column. As for your sorting issue, I still need more information. What column are you sorting by, and what other levels of sort are you applying?

So Lafferty, How could I take this code for unique numbers and search sheet "forecast" to find the next unique number and in the range "A3:A2000" and return the new unique id to a textbox in a userform as the userform initializes?

does that make sense? I want a userform's textbox (on initialize) to check sheet "Forecast" and create a new unique id that is returned to textbox_UniqueID in the form.

Thanks in advance!

bg_enigma1,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.