{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Problema","Código","Base"],"not_rendered":{"charts":0,"images":2,"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":"Problema","index":0,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Principales Conceptos a aplicar"]
[null,"Comandos Control - X"]
[null,"User Form"]
[null,"Macros"]
[]
[null,"Problema a Desarrollar "]
[null,"1) Se tiene una base de datos con tres campos (Código, Nombre y Edad)"]
[null,"2) Crear un User Form que permita agregar datos en la primera fila, previo insertar una fila en blanco"]
[null,"3) En página siguiente aparece el código"]
[null,"3) En página sub-siguiente se puede probar el código"]

{"sheet":"Código","index":1,"n_rows":27,"n_cols":1,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["Inserta y Copia"]
[]
["Private Sub CommandButton1_Click()"]
["Inserta Fila 7"]
["Rows(\"7:7\").Select"]
["    Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove"]
["    "]
["Copia Celda Codigo en A7"]
["Sheets(\"Base\").Range(\"A7\").Value = UserForm1.TextBox1.Value"]
[]
["Copia Celda Nombre en B7"]
["Sheets(\"Base\").Range(\"B7\").Value = UserForm1.TextBox2.Value"]
[]
["Copia Celda Edad en C7"]
["Sheets(\"Base\").Range(\"C7\").Value = UserForm1.TextBox3.Value"]
["    "]
["End Sub"]
[]
["Carga el Form"]
[]
["Private Sub CommandButton2_Click()"]
["Unload Me"]
["End Sub"]

{"sheet":"Base","index":2,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["Codigo","Nombre","Edad"]
[11,"Anita",45]
[111,"Antonio Sepulveda",56]
[11,"Lus araya",45]
[11,"Pedro Paz",22]
[78,"Melinda Saez",26]