{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"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":"Sheet1","index":0,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,null,"Overview:"]
[]
[null,null,"The object of this lesson is to compose a basic UserForm and place some controls onto it."]
[]
[null,null,"A macro named ShowClientForm is in place with this workbook to show the UserForm."]
[null,null,"You can run the macro (that is, show the UserForm) by pressing the Alt+F8 key combination"]
[null,null,"to call the Macro dialog box.   From the Macro dialog box, select your macro's name in the"]
[null,null,"large white pane, and click the Run button.  You can also view the UserForm by clicking"]
[null,null,"the Forms button in cell A1 that is labeled \"Show Form\"."]
[]
[null,null,"To view the ShowClientForm macro, follow these steps:"]
[null,null,"• From this worksheet, press the Alt+F11 key combination to go to the Visual Basic Editor."]
[null,null,"• Press Ctrl+R to ensure that you can see the Project Explorer window in the VBE."]
[null,null,"• In the Project Explorer window, find the name of this workbook.  The name will be in bold font"]
[null,null,"   and will look like VBAProject(TryIt_Lesson21.xlsm).  Expand that project name to expose three"]
[null,null,"   yellow folders.   One yellow folder will be named Microsoft Excel Objects, another yellow folder"]
[null,null,"   will be named Forms, and a third yellow folder will be named Modules."]
[null,null,"• Expand the Modules folder and find the module named Module1.  The ShowClientForm macro"]
[null,null,"   is in Module1.   To see the code, double-click the Module1 name, or right-click the Module1"]
[null,null,"    name, and select View Code."]
[null,null,"• To view the UserForm in the VBE, expand the yellow folder named Forms and you will see"]
[null,null,"   an object named frmClients.   To see the UserForm in its design state, either double-click the"]
[null,null,"   frmClients name, or right-click the frmClients name and select View Object."]
[null,null,"• When you want to return to this worksheet, you can exit the Visual Basic Editor by pressing"]
[null,null,"    the Alt+Q key combination."]