Userform to populate 2 sheets and generate unique ID

[edwinjeffconcepcion]

Hi Everyone,

I am very new to excel vba code, macro and vba userform. I was able to device my first vba userform file by this site's help that's why I registered.


Now I have a new project that needs another vba, macro based with vba userform database.


I need a userform that can compile data to 2 different sheet. to sheet1 and sheet2 by using the userform and able to generate a unique control ID.
Labels are as follows:


1.Control ID: "this can generate automatic that starts to 100000" everytime i open the form
2. Date: "Textbox only"
3. Document Name: "Textbox only"
4. Description: "Textbox only"
5. Document Status: "this is a combo box with choices: For Signature, For review, Paid, For Cancellation
6. Department Status: "this is a combo box with choices: For Sign GA, For Sign IT, For Sign Corp Plan, FOr Sign Mgt, Received Acctg/Treasury, cheque released.
7. Notes" "Textbox only"


Then I have 3 buttons that can do to the data input in the userform:


Add - adds all the details inserted in the form above to 2 different sheets; Sheet1 and sheet2
Update - updates the status of the details and able to send the update in sheet1 and sheet2. The only difference is that in sheet1 details are just updated
and details are still on the same cell where it went previously and in sheet2 details become a new input.
Close form- close the form


I am not sure what codes to use and how will it be working. I am facing a problem because I need to not have duplicate input in sheet1 and allow duplicate input
in sheet2 (just to know the history of a particular details).


LAStly, i have one button which I can generate reports in sheet2..


I hope I have explained what help I need. looking forward everyone!


thank you!