View Full Version : Add new project number to user form

07-22-2015, 06:05 AM
I have a user form that people use to populate data into a sheet. What I want to happen is for the next project number to automatically populate when the form opens. The projects are numbered starting with 1 in column A. So if the user opens the form and there are already 10 projects on the sheet the form should pop up with 11 in the Project ID field. Just not sure on how to accomplish this.

07-22-2015, 08:09 AM
In the Initialize or Activate event of the form, you can populate the control using
Application.Max(Sheets("whatever").Range("A:A")) + 1