{"id":68,"date":"2011-10-10T16:32:52","date_gmt":"2011-10-10T16:32:52","guid":{"rendered":"http:\/\/www.edcortes.ph\/?p=159"},"modified":"2021-07-11T08:00:12","modified_gmt":"2021-07-11T08:00:12","slug":"getting-started-with-vba-in-excel-2010-part-2","status":"publish","type":"post","link":"https:\/\/emcortes.com\/?p=68","title":{"rendered":"Getting Started with VBA in Excel 2010 (Part 2)"},"content":{"rendered":"

Now that you know something about how Microsoft Excel 2010 exposes its object model, you can try calling object methods and setting object properties. To do so, you must write your code in a place and in a way that Office can understand; typically, by using the Visual Basic Editor. Although it is installed by default, many users do not know that it is even available until it is enabled on the ribbon.<\/p>\n

Developer Tab<\/h4>\n

All Office 2010 applications use the ribbon. One tab on the ribbon is the Developer<\/strong> tab, where you access the Visual Basic Editor and other developer tools. Because Office 2010 does not display the Developer<\/strong> tab by default, you must enable it using the following procedure:<\/p>\n

To enable the Developer tab<\/h3>\n
\n
    \n
  1. On the File<\/strong> tab, choose Options<\/strong> to open the Excel Options<\/strong> dialog box.<\/li>\n
  2. Click Customize Ribbon<\/strong> on the left side of the dialog box.<\/li>\n
  3. Under Choose commands from<\/strong> on the left side of the dialog box, select Popular Commands<\/strong>.<\/li>\n
  4. Under Customize the ribbon<\/strong> on the right side of the dialog box, select Main tabs<\/strong>, and then select the Developer<\/strong> check box.<\/li>\n
  5. Click OK<\/strong>.<\/li>\n<\/ol>\n<\/div>\n

    After Excel displays the Developer<\/strong> tab, note the location of the Visual Basic<\/strong>, Macros<\/strong>, and Macro Security<\/strong> buttons on the tab.<\/p>\n

    \"\"<\/a><\/div>\n
    \u00a0<\/div>\n
    \n

    Security Issues<\/h4>\n
    \n

    Click the Macro Security<\/strong> button to specify which macros can run and under what conditions. Although rogue macro code can seriously damage your computer, security conditions that prevent you from running helpful macros can seriously undermine your productivity. Macro security is a complex and involved topic that you should study and understand if you work with Excel macros.<\/p>\n

    For the purposes of this article, be aware that if the Security Warning: Macros have been disabled<\/strong> bar appears between the ribbon and the worksheet when you open a workbook that contains a macro, you can click the Enable Content<\/strong> button to enable the macros.<\/p>\n

    Also, as a security measure, you cannot save a macro in the default Excel file format (.xlsx); instead, you must save the macro in a file with a special extension, .xlsm.<\/p>\n<\/div>\n

    Visual Basic Editor<\/h4>\n

    This following procedure shows you how to create a new blank workbook in which to store your macros. You can then save the workbook in the .xlsm format.<\/p>\n

    To create a new blank workbook<\/h3>\n
    \n
      \n
    1. Click the Macros<\/strong> button on the Developer tab.<\/li>\n
    2. In the Macro<\/strong> dialog box that appears, type, Hello<\/strong> under Macro Name<\/strong>.<\/li>\n
    3. Click the Create<\/strong> button to open the Visual Basic Editor with the outlines of a new macro already typed in.<\/li>\n<\/ol>\n<\/div>\n

      VBA is a full-featured programming language with a correspondingly full-featured programming environment. This article examines only those tools that you use to get started with programming, and that excludes most of the tools in the Visual Basic Editor. With this caveat, close the Properties<\/strong> window on the left side of the Visual Basic Editor, and ignore the two dropdown lists that appear above the code.<\/p>\n

      \"\"<\/a><\/div>\n
      \u00a0<\/div>\n

      The Visual Basic Editor contains the following code.<\/p>\n