I am creating a fairly large project. Which will accept data entered into a user form and send it to Sheet 2(Log). The Dashboard part I have down without issue it is the log and vba side I need help with. Below is format and areas I could use some assistance as this is my first time using VBA and I certianly would like to create something impressive to all that will see it.
Sheet 1(Cover)- Simply 3 Buttons
Button 1- Enter Data into user form- Need help formatting button to user form 1 (Need userform to automatically move to next open row in the log and assign it a 4 digit reference number).
Button 2- Edit a log entry- Pull up User form 2 enter the reference number and it will pull up that entry in User form 1 and have the ability to edit that entry.
Button 3- Format to view the log
Other- User Form 1 has 30 seperate entry fields with labels. Combination of Combo & Text box. Need proper code to send the info to the log and assign that entry its own 4 digit number. also need to format each entry field to the correct column in the log. Also need to format combo box with the proper choices.
User form 2- will have spot to enter the 4 digit id number of an entry upon clicking the ok button it will bring up user form 1 with the fields populated to be able to edit the info.
I sincerely appreciate any help that can be given. If someone needs further information please let me know. Thanks in advance.
Sheet 1(Cover)- Simply 3 Buttons
Button 1- Enter Data into user form- Need help formatting button to user form 1 (Need userform to automatically move to next open row in the log and assign it a 4 digit reference number).
Button 2- Edit a log entry- Pull up User form 2 enter the reference number and it will pull up that entry in User form 1 and have the ability to edit that entry.
Button 3- Format to view the log
Other- User Form 1 has 30 seperate entry fields with labels. Combination of Combo & Text box. Need proper code to send the info to the log and assign that entry its own 4 digit number. also need to format each entry field to the correct column in the log. Also need to format combo box with the proper choices.
User form 2- will have spot to enter the 4 digit id number of an entry upon clicking the ok button it will bring up user form 1 with the fields populated to be able to edit the info.
I sincerely appreciate any help that can be given. If someone needs further information please let me know. Thanks in advance.
