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

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!