To use VBA, make sure you have access to the Developer tab in the Menu Ribbon by checking the Show Developer tab in the Ribbon box in the Excel Options dialog box and clicking OK. To use the VBA interface, go to the Developer tab and select Visual Basic.  From the INSERT menu, choose UserForm. From the TOOLBOX, choose the Label icon and drag it to the form. Select Properties from the popup menu by right-clicking on the label. In the Caption property, type “Starting Invoice Date.” Drag the Textbox icon from the Toolbox to the “Starting Invoice Date” label on the form. Select Properties from the popup menu by right-clicking in the textbox. In the Name property, type “txtStartDate.”  Steps 3–6 are repeated to create a new label and textbox with the following properties: label caption: “Ending Invoice Date” The textbox’s name is “txtEndDate.”  Choose a command button from the TOOLBOX and drag it to the form. Select Properties from the popup menu by right-clicking on the command button. Type “Generate Report” in the Caption property. Okay, we just finished the user interface where you can enter a date range for the report to be based on. Now we must enter the code that will generate the report by querying the Visual database. To open the code window, double-click the command button “Generate Report.” 11. Before we begin inputting code, we must first create a reference to the Visual database. From the TOOLS menu, choose References… 12. Put a tick next to Microsoft ActiveX Data Objects 2.6 Library. Select OK. 13.Add the following code after “Private Sub CommandButton1 Click()” in the Code window.