{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","Data"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":182,"n_cols":16,"rows_kept":182,"cut":false,"hidden":false,"merged":[]}
[]
["TUTORIAL TO CREATE BASIC USERFORM AND PASS VALUES TO WORKSHEET"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This shape is linked to the LaunchForm procedure in Step 10"]
["1. Access the Visual Basic Editor (Alt + F11)"]
[]
["2. Insert Userform (Insert > Userform)"]
[]
["3. Insert 3 Labels, 2 textboxes, 2 command buttons and 1 combobox"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["4. Change UserForm Control Captions and rename controls"]
["a. Access the properties window (View > Properties Window)"]
["b. Rename controls and change captions (Note: control names cannot contain spaces)"]
[]
[null,"Name Before","Name After","Caption"]
[null,"UserForm1","frmDataEntry","Data Entry"]
[null,"Label1","lblFirstName","First Name"]
[null,"Label2","lblLastName","Last Name"]
[null,"Label3","lblFavoriteSport","Favorite Sport"]
[null,"TextBox1","txtFirstName"]
[null,"TextBox2","txtLastName"]
[null,"ComboBox1","cboFavoriteSport"]
[null,"CommandButton1","cmdCancel","Cancel"]
[null,"CommandButton2","cmdSubmit","Submit"]
[]
[]
[]
[]
["5. Create New Code Module (Insert > Module)"]
[]
["6. Create Sub Procedure to Launch UserForm"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["7. Create UserForm Initialize event to update Favorite Sport Combobox Values (Using the .AddItem Method)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["8. Create cmdCancel Code to close the UserForm"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["9. Create cmdSubmit Code to pass values to the 'Data' worksheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["10. Create shape and link the LaunchForm Sub Procedure to the shape"]
[]
["a. Create Shape and format to your specifications"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["b. Link shape to LaunchForm Sub Procedure"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["11. Now when you enter values in the UserForm they are passed to the 'Data' worksheet"]

{"sheet":"Data","index":1,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["First Name","Last Name","Favorite Sport"]
["Matt","Mickle","Football"]
["","",""]
["","",""]