Hello,
I need help! I have created a UserForm to create a document number. The users choose 3 options - Project code, Discipline code, and Doc Type from drop downs. Depending on their choices, I need the next sequential number to populate in the Sequential Number text box on the form.
On my Data spreadsheet:
Column L = the project code
Column M = the discipline code
Column N = Doc Type
Column O = The next sequential number. The number is: 00001 - if the first time those 3 specific items items have been selected and 00002 - if its the second time they have been selected, and so on...
So far, the code I have written allows users to choose from the Project, Discipline and Doc Type options - they Click a 'Create' command button and it populates the data sheet with those 3 codes. I am having trouble writing code that will make the form read each of the 3 conditions (columns) and populate the 'Sequence' text box on the form with the next sequential number.
I am thinking maybe I need a 3 command button process, where first they choose from the 3 drop downs - click create, and then have another command button ('get sequence' ) that would read the each column and then populate the text box - then when they click close the generated sequence number will populate on the actual date sheet?
I need help! I have created a UserForm to create a document number. The users choose 3 options - Project code, Discipline code, and Doc Type from drop downs. Depending on their choices, I need the next sequential number to populate in the Sequential Number text box on the form.
On my Data spreadsheet:
Column L = the project code
Column M = the discipline code
Column N = Doc Type
Column O = The next sequential number. The number is: 00001 - if the first time those 3 specific items items have been selected and 00002 - if its the second time they have been selected, and so on...
So far, the code I have written allows users to choose from the Project, Discipline and Doc Type options - they Click a 'Create' command button and it populates the data sheet with those 3 codes. I am having trouble writing code that will make the form read each of the 3 conditions (columns) and populate the 'Sequence' text box on the form with the next sequential number.
I am thinking maybe I need a 3 command button process, where first they choose from the 3 drop downs - click create, and then have another command button ('get sequence' ) that would read the each column and then populate the text box - then when they click close the generated sequence number will populate on the actual date sheet?