{"id":25556532,"date":"2023-03-17T12:37:16","date_gmt":"2023-03-17T07:07:16","guid":{"rendered":"https:\/\/entri.app\/blog\/?p=25556532"},"modified":"2023-03-21T13:59:00","modified_gmt":"2023-03-21T08:29:00","slug":"vba-in-excel","status":"publish","type":"post","link":"https:\/\/entri.app\/blog\/vba-in-excel\/","title":{"rendered":"VBA in Excel &#8211; Definition, Examples, How to Use"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_79_2 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-69e154dd343db\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-69e154dd343db\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/entri.app\/blog\/vba-in-excel\/#How_to_Access_VBA_in_Excel\" >How to Access VBA in Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/entri.app\/blog\/vba-in-excel\/#How_is_VBA_used\" >How is VBA used?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/entri.app\/blog\/vba-in-excel\/#Common_uses_of_VBA_among_finance_professionals\" >Common uses of VBA among finance professionals<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/entri.app\/blog\/vba-in-excel\/#Why_use_Excel_VBA\" >Why use Excel VBA?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/entri.app\/blog\/vba-in-excel\/#Where_to_code_Excel_VBA\" >Where to code Excel VBA<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/entri.app\/blog\/vba-in-excel\/#VBA_shortcuts_in_Excel\" >VBA shortcuts in Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/entri.app\/blog\/vba-in-excel\/#What_Is_VBA_Used_for\" >What Is VBA Used for?<\/a><\/li><\/ul><\/nav><\/div>\n<div class=\"loc article-pre-content\">\n<header id=\"article-header_1-0\" class=\"comp right-rail__offset article-header mntl-block\">\n<div id=\"article-meta_1-0\" class=\"comp article-meta mntl-block\" data-tracking-container=\"true\">\n<div id=\"finance-bylines_1-0\" class=\"comp finance-bylines mntl-bylines\">\n<div id=\"mntl-bylines__group_1-0-2\" class=\"comp mntl-bylines__group--fact_checker mntl-bylines__group mntl-block\">\n<div id=\"mntl-bylines__item_1-0-2\" class=\"comp mntl-bylines__item mntl-attribution__item\">\n<div class=\"mntl-dynamic-tooltip--trigger\" data-tooltip=\"Ryan Eichler holds a B.S.B.A with a concentration in Finance from Boston University. He has held positions in, and has deep experience with, expense auditing, personal finance, real estate, as well as fact checking &amp; editing.\" data-inline-tooltip=\"true\" data-tooltip-position-x=\"left\" data-tooltip-position-y=\"top\">VBA is an abbreviation for Visual Basic for Application. VBA is a programming language that was developed by Microsoft Corp., and it is integrated into the major Microsoft Office applications, such as Word, Excel, and Access.<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/header>\n<\/div>\n<p>The VBA programming language allows users to access functions beyond what is available in the MS Office applications. Users can also use VBA to customize applications to meet the specific needs of their business, such as creating user-defined functions, automating computer processes, and accessing\u00a0Windows APIs.<\/p>\n<p style=\"text-align: center;\"><strong><a href=\"https:\/\/entri.app\/course\/data-science-and-machine-learning-course\/\" target=\"_blank\" rel=\"noopener\">Looking for a Data Science Career? Explore Here!\u00a0<\/a><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong style=\"color: #1d1f20; font-size: 1.953em;\">VBA in Excel &#8211; Key Highlights<\/strong><\/p>\n<div class=\"wrap-takeaways\">\n<div class=\"takeaways\">\n<ul>\n<li>Learning VBA programming can help Microsoft Office users access functions beyond what is directly available in the various Office applications.<\/li>\n<li>VBA can be used to analyze large amounts of data, create and maintain complicated financial models.<\/li>\n<li>Recording a macro is relatively simple and requires no inherent knowledge of the VBA code and will work for simple processes. However, this method is not very customizable.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<p>* By submitting your email address, you consent to receive email messages (including discounts and newsletters) regarding Corporate Finance Institute and its products and services and other matters (including the products and services of Corporate Finance Institute&#8217;s affiliates and other organizations). You may withdraw your consent at any time.<\/p>\n<div class=\"klaviyo-form-U7vzbr klaviyo-form form-version-cid-1\">\n<div class=\"needsclick kl-private-reset-css-Xuajs1\">\n<form>\n<div class=\"needsclick kl-private-reset-css-Xuajs1\">\n<div class=\"needsclick kl-private-reset-css-Xuajs1\" data-testid=\"form-row\">\n<div class=\"needsclick kl-private-reset-css-Xuajs1\" data-testid=\"form-component\">\n<div class=\"kl-private-reset-css-Xuajs1 go3176171171\">\n<p style=\"text-align: center;\"><a href=\"https:\/\/entri.app\/course\/data-science-and-machine-learning-course\/\" target=\"_blank\" rel=\"noopener\"><strong>Ready to take your data science skills to the next level? Sign up for a free demo today!<\/strong><\/a><\/p>\n<h2 id=\"mntl-sc-block_1-0-19\" class=\"comp mntl-sc-block finance-sc-block-subheading mntl-sc-block-subheading\"><span class=\"ez-toc-section\" id=\"How_to_Access_VBA_in_Excel\"><\/span><strong><span class=\"mntl-sc-block-subheading__text\">How to Access VBA in Excel<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p id=\"mntl-sc-block_1-0-20\" class=\"comp mntl-sc-block finance-sc-block-html mntl-sc-block-html\">To access VBA in Excel, simply press Alt + F11. Your existing Excel workbook will remain running, but a new window will appear for Microsoft Visual Basic for Applications. The top left of the VBA window will show the current projects; in the example below, the InvestopediaProject file is ready to receive VBA code.<\/p>\n<div id=\"mntl-sc-block_1-0-21\" class=\"comp mntl-sc-block mntl-sc-block-adslot mntl-block\"><\/div>\n<figure id=\"mntl-sc-block_1-0-22\" class=\"comp mntl-sc-block-image inline-image mntl-sc-block finance-sc-block-image mntl-sc-block-universal-image figure-landscape figure-high-res\">\n<div class=\"figure-media\">\n<div class=\"img-placeholder\">\n<figure style=\"width: 861px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" id=\"mntl-sc-block-image_1-0\" class=\"universal-image__image lazyloaded\" src=\"https:\/\/www.investopedia.com\/thmb\/Jh_R1unmKagl5IORSKL8si5aSC0=\/1500x0\/filters:no_upscale():max_bytes(150000):strip_icc():format(webp)\/VBA1-1ab86da975a0436b91cbbc0f6688ed8f.JPG\" alt=\"VBA, Project Window\" width=\"861\" height=\"404\" data-src=\"https:\/\/www.investopedia.com\/thmb\/Jh_R1unmKagl5IORSKL8si5aSC0=\/1500x0\/filters:no_upscale():max_bytes(150000):strip_icc():format(webp)\/VBA1-1ab86da975a0436b91cbbc0f6688ed8f.JPG\" data-srcset=\"https:\/\/www.investopedia.com\/thmb\/WM4olt-gEhn8YxpT4AatamqEU5E=\/750x0\/filters:no_upscale():max_bytes(150000):strip_icc():format(webp)\/VBA1-1ab86da975a0436b91cbbc0f6688ed8f.JPG 750w\" data-sizes=\"750px\" data-expand=\"300\" data-click-tracked=\"true\" data-tracking-container=\"true\" data-img-lightbox=\"true\" \/><figcaption class=\"wp-caption-text\">VBA, Project Window<\/figcaption><\/figure>\n<\/div>\n<\/div><figcaption id=\"mntl-figure-caption_1-0\" class=\"comp figure-caption mntl-figure-caption figure-article-caption\"><\/figcaption><\/figure>\n<p id=\"mntl-sc-block_1-0-23\" class=\"comp mntl-sc-block finance-sc-block-html mntl-sc-block-html\">In the bottom left, the window displays the properties of the selected project. As different projects or workbooks are selected, different properties are listed. These properties are listed alphabetically by default, though they can be sorted by category.<\/p>\n<div id=\"mntl-sc-block_1-0-24\" class=\"comp mntl-sc-block mntl-sc-block-adslot mntl-block\"><\/div>\n<figure id=\"mntl-sc-block_1-0-25\" class=\"comp mntl-sc-block-image inline-image mntl-sc-block finance-sc-block-image mntl-sc-block-universal-image figure-landscape figure-high-res\">\n<div class=\"figure-media\">\n<div class=\"img-placeholder\">\n<figure style=\"width: 1041px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" id=\"mntl-sc-block-image_1-0-1\" class=\"universal-image__image lazyloaded\" src=\"https:\/\/www.investopedia.com\/thmb\/ew58nyRQxYfZ3lyxJxvW8PtO3sg=\/1500x0\/filters:no_upscale():max_bytes(150000):strip_icc():format(webp)\/VBA2-410b3700e23041db92c5c333fe41cbfe.JPG\" alt=\"VBA Example, Properties\" width=\"1041\" height=\"534\" data-src=\"https:\/\/www.investopedia.com\/thmb\/ew58nyRQxYfZ3lyxJxvW8PtO3sg=\/1500x0\/filters:no_upscale():max_bytes(150000):strip_icc():format(webp)\/VBA2-410b3700e23041db92c5c333fe41cbfe.JPG\" data-srcset=\"https:\/\/www.investopedia.com\/thmb\/LVAP1YALjqFazIgJ2E5ClrKVlMc=\/750x0\/filters:no_upscale():max_bytes(150000):strip_icc():format(webp)\/VBA2-410b3700e23041db92c5c333fe41cbfe.JPG 750w\" data-sizes=\"750px\" data-expand=\"300\" data-click-tracked=\"true\" data-tracking-container=\"true\" data-img-lightbox=\"true\" \/><figcaption class=\"wp-caption-text\">VBA Example, Properties<\/figcaption><\/figure>\n<\/div>\n<\/div><figcaption id=\"mntl-figure-caption_1-0-1\" class=\"comp figure-caption mntl-figure-caption figure-article-caption\"><\/figcaption><\/figure>\n<p id=\"mntl-sc-block_1-0-26\" class=\"comp mntl-sc-block finance-sc-block-html mntl-sc-block-html\">By double-clicking on a project on the top left, a new window appears. There is no information in this area, though there are two dropdowns that say &#8220;(General)&#8221; and &#8220;(Declarations). This is the coding window for VBA code to be directly entered into.<\/p>\n<div id=\"mntl-sc-block_1-0-27\" class=\"comp mntl-sc-block mntl-sc-block-adslot mntl-block\"><\/div>\n<figure id=\"mntl-sc-block_1-0-28\" class=\"comp mntl-sc-block-image inline-image mntl-sc-block finance-sc-block-image mntl-sc-block-universal-image figure-landscape figure-high-res\">\n<div class=\"figure-media\">\n<div class=\"img-placeholder\">\n<figure style=\"width: 1243px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" id=\"mntl-sc-block-image_1-0-2\" class=\"universal-image__image lazyloaded\" src=\"https:\/\/www.investopedia.com\/thmb\/gwIvCgqa-E5U2CZn2IiHFPHzjNo=\/1500x0\/filters:no_upscale():max_bytes(150000):strip_icc():format(webp)\/VBA3-246bb110a31243989593d29ccad9b0e5.JPG\" alt=\"VBA Example, Code\" width=\"1243\" height=\"690\" data-src=\"https:\/\/www.investopedia.com\/thmb\/gwIvCgqa-E5U2CZn2IiHFPHzjNo=\/1500x0\/filters:no_upscale():max_bytes(150000):strip_icc():format(webp)\/VBA3-246bb110a31243989593d29ccad9b0e5.JPG\" data-srcset=\"https:\/\/www.investopedia.com\/thmb\/jN5FZp6Kxo49bkFY7B3StaShsc8=\/750x0\/filters:no_upscale():max_bytes(150000):strip_icc():format(webp)\/VBA3-246bb110a31243989593d29ccad9b0e5.JPG 750w\" data-sizes=\"750px\" data-expand=\"300\" data-click-tracked=\"true\" data-tracking-container=\"true\" data-img-lightbox=\"true\" \/><figcaption class=\"wp-caption-text\">VBA Example, Code<\/figcaption><\/figure>\n<\/div>\n<\/div><figcaption id=\"mntl-figure-caption_1-0-2\" class=\"comp figure-caption mntl-figure-caption figure-article-caption\"><\/figcaption><\/figure>\n<p id=\"mntl-sc-block_1-0-29\" class=\"comp mntl-sc-block finance-sc-block-html mntl-sc-block-html\">An example of VBA code has been entered below.<\/p>\n<div id=\"mntl-sc-block_1-0-30\" class=\"comp mntl-sc-block mntl-sc-block-adslot mntl-block\"><\/div>\n<figure id=\"mntl-sc-block_1-0-31\" class=\"comp mntl-sc-block-image inline-image mntl-sc-block finance-sc-block-image mntl-sc-block-universal-image figure-landscape figure-high-res\">\n<div class=\"figure-media\">\n<div class=\"img-placeholder\">\n<figure style=\"width: 1172px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" id=\"mntl-sc-block-image_1-0-3\" class=\"universal-image__image lazyloaded\" src=\"https:\/\/www.investopedia.com\/thmb\/iRNlXlZw2_hbkaIcv62-oblDKCI=\/1500x0\/filters:no_upscale():max_bytes(150000):strip_icc():format(webp)\/VBA3.1-19c0f50907074070901f7509c489e361.JPG\" alt=\"VBA Example, Code with Coding\" width=\"1172\" height=\"639\" data-src=\"https:\/\/www.investopedia.com\/thmb\/iRNlXlZw2_hbkaIcv62-oblDKCI=\/1500x0\/filters:no_upscale():max_bytes(150000):strip_icc():format(webp)\/VBA3.1-19c0f50907074070901f7509c489e361.JPG\" data-srcset=\"https:\/\/www.investopedia.com\/thmb\/x68SZ0atxwbCNiUs3BkY89W4wuU=\/750x0\/filters:no_upscale():max_bytes(150000):strip_icc():format(webp)\/VBA3.1-19c0f50907074070901f7509c489e361.JPG 750w\" data-sizes=\"750px\" data-expand=\"300\" data-click-tracked=\"true\" data-tracking-container=\"true\" data-img-lightbox=\"true\" \/><figcaption class=\"wp-caption-text\">VBA Example, Code with Coding<\/figcaption><\/figure>\n<\/div>\n<\/div><figcaption id=\"mntl-figure-caption_1-0-3\" class=\"comp figure-caption mntl-figure-caption figure-article-caption\"><\/figcaption><\/figure>\n<p id=\"mntl-sc-block_1-0-32\" class=\"comp mntl-sc-block finance-sc-block-html mntl-sc-block-html\">Last, there are many important buttons and tools residing on the toolbar. The items below highlighted in yellow are the run, break, and reset toggles for the VBA code. The run button executes the code, the break button pauses the activity of the code, and the reset stops the execution of the code and brings the process back to the starting position of the code.<\/p>\n<div id=\"mntl-sc-block_1-0-33\" class=\"comp mntl-sc-block mntl-sc-block-adslot mntl-block\"><\/div>\n<figure id=\"mntl-sc-block_1-0-34\" class=\"comp mntl-sc-block-image inline-image mntl-sc-block finance-sc-block-image mntl-sc-block-universal-image figure-landscape figure-high-res\">\n<div class=\"figure-media\">\n<div class=\"img-placeholder\">\n<figure style=\"width: 834px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" id=\"mntl-sc-block-image_1-0-4\" class=\"universal-image__image lazyloaded\" src=\"https:\/\/www.investopedia.com\/thmb\/mZ19B1PqyhZu7xavcqryG-ReHr4=\/1500x0\/filters:no_upscale():max_bytes(150000):strip_icc():format(webp)\/VBA4-9e6f8b132c4c402ca84c702c9ff46650.JPG\" alt=\"VBA Example, Toolbar\" width=\"834\" height=\"320\" data-src=\"https:\/\/www.investopedia.com\/thmb\/mZ19B1PqyhZu7xavcqryG-ReHr4=\/1500x0\/filters:no_upscale():max_bytes(150000):strip_icc():format(webp)\/VBA4-9e6f8b132c4c402ca84c702c9ff46650.JPG\" data-srcset=\"https:\/\/www.investopedia.com\/thmb\/wT-pq9XdJLhqPV4CZL7QdCR_CfE=\/750x0\/filters:no_upscale():max_bytes(150000):strip_icc():format(webp)\/VBA4-9e6f8b132c4c402ca84c702c9ff46650.JPG 750w\" data-sizes=\"750px\" data-expand=\"300\" data-click-tracked=\"true\" data-tracking-container=\"true\" data-img-lightbox=\"true\" \/><figcaption class=\"wp-caption-text\">VBA Example, Toolbar<\/figcaption><\/figure>\n<\/div>\n<\/div><figcaption id=\"mntl-figure-caption_1-0-4\" class=\"comp figure-caption mntl-figure-caption figure-article-caption\"><\/figcaption><\/figure>\n<p id=\"mntl-sc-block_1-0-36\" class=\"comp mntl-sc-block finance-sc-block-html mntl-sc-block-html\">At its core, finance is about manipulating huge amounts of data; hence, VBA is endemic to the\u00a0financial services sector. If you work in finance, VBA is likely running within applications that you use each day, whether you&#8217;re aware of it or not. Some jobs in the sector require prior knowledge of VBA, and some do not. With VBA, you can:<\/p>\n<div id=\"mntl-sc-block_1-0-37\" class=\"comp mntl-sc-block mntl-sc-block-adslot mntl-block\"><\/div>\n<ul id=\"mntl-sc-block_1-0-38\" class=\"comp mntl-sc-block finance-sc-block-html mntl-sc-block-html\">\n<li><strong>Write macros.\u00a0<\/strong>Macros allow financial professionals\u2014whether accountants, commercial bankers,\u00a0investment bankers, research analysts, salesmen, traders, portfolio managers, clerks, or administrators\u2014to analyze and adjust huge amounts of data quickly.<\/li>\n<li><strong>Update data.<\/strong>\u00a0You can use VBA in Excel to create and maintain complex trading, pricing, and risk-management models, forecast sales and earnings, and to generate\u00a0financial ratios.<\/li>\n<li><strong>Perform scenario-analysis.<\/strong>\u00a0With Visual Basic for Applications, you can create various portfolio-management and\u00a0investment scenarios. This includes filtering through different situations that may impact outcomes differently.<\/li>\n<li><strong>Organize information.<\/strong>\u00a0You also may use VBA to produce lists of customers\u2019 names or any other content; create invoices, forms, and charts; analyze scientific data, and manage data display for budgets and forecasting.<\/li>\n<li><strong>Be unconventional.<\/strong>\u00a0VBA can be used to copy and paste values, adjust cell styles for an entire workbook, and strike accelerator keys. You can perform very normal tasks but perform them in an easier, automated manner.<\/li>\n<li><strong>Prompt action.<\/strong> VBA can be used to interact with users. For example, you may need a user&#8217;s input for their first and last name to put on a form. VBA can be used to prompt a user in a way that makes this input unavoidably mandatory.<\/li>\n<\/ul>\n<div id=\"mntl-sc-block_1-0-40\" class=\"comp mntl-sc-block finance-sc-block-callout mntl-block\">\n<div id=\"mntl-sc-block_1-0-41\" class=\"comp theme-tip mntl-sc-block mntl-sc-block-callout mntl-block\" data-tracking-id=\"mntl-sc-block-callout\" data-tracking-container=\"true\">\n<div id=\"mntl-sc-block-callout-body_1-0-2\" class=\"comp mntl-sc-block-callout-body mntl-text-block\">\n<p>There are many forums online that provide VBA code, allowing you to simply copy and paste the code for your personal use. Be cautious when using someone else&#8217;s code, especially if you are unfamiliar with the source, individual, or logic of the code.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/form>\n<\/div>\n<\/div>\n<h2 id=\"how-is-vba-used\"><span class=\"ez-toc-section\" id=\"How_is_VBA_used\"><\/span><strong>How is VBA used?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>VBA is used to perform different functions, and different types of users use the programming language for various functions. The following are the different parties that use VBA:<\/p>\n<h4><b>1. General users<\/b><\/h4>\n<p>Most users regularly use MS Office applications such as\u00a0Excel\u00a0in their routine. VBA language is included in the MS Office package at no cost to the user. VBA is used to automate tasks and perform several other functions beyond creating and organizing spreadsheets.<\/p>\n<p>For example, users need to automate some aspects of Excel, such as repetitive tasks, frequent tasks, generating reports, etc. The user can create a VBA program (macro) within Excel that generates, formats, and prints monthly sales reports with graphical representation such as\u00a0bar charts. They can execute the program with a single click, and Excel will automatically generate the reports with ease as per the needs of the company.<\/p>\n<h4><b>2. Computer professionals<\/b><\/h4>\n<p>Computer professionals can use VBAs to perform more complex tasks that would otherwise take longer time and more resources to complete. For example, they can use VBAs to create custom add-ins for Excel that provide additional functionality to the application by introducing new functions that are not available in Excel.<\/p>\n<p>VBA also helps computer professionals perform complex functions, such as replicating large lines of code, designing languages within MS Office applications, and merging the functions of two or more different programs.<\/p>\n<h4><b>3. Corporate users<\/b><\/h4>\n<p>VBA is not only useful to individuals, but also to corporate users. Companies can use the VBA programming language to automate key business procedures and internal processes. Functions such as\u00a0accounting procedures, tracking minutes, processing of sales orders in real-time, calculating complex data, etc., can be implemented using VBA.<\/p>\n<p>VBA can automate the above-mentioned tasks to increase the efficiency of internal business processes. It also allows corporations to consolidate their data in the cloud to make it accessible from any location around the world.<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/entri.app\/course\/data-science-and-machine-learning-course\/\" target=\"_blank\" rel=\"noopener\"><strong>Take your data science skills to the next level! Sign up for a free demo today!<\/strong><\/a><\/p>\n<h2 id=\"common-uses-of-vba-among-finance-professionals\"><span class=\"ez-toc-section\" id=\"Common_uses_of_VBA_among_finance_professionals\"><\/span><strong>Common uses of VBA among finance professionals<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The following are some of the ways in which finance professionals use VBA in their work:<\/p>\n<h4><b>1. Analyze huge amounts of data<\/b><\/h4>\n<p>Finance professionals, such as portfolio managers,\u00a0financial analysts, traders, and investment bankers, often need to deal with large volumes of data. They are required to review all the data and use the information to make critical buy or sell decisions. The professionals can use VBA to create macros that facilitate speedy analysis of the data.<\/p>\n<p>Once the logic is defined and the important variables are specified, the finance professionals should feed the large volumes of data into the relevant cells and get results with a click of a button. Also, as long the correct data is added to the program, the data output will be more accurate compared to the output obtained manually since humans are bound to make mistakes.<\/p>\n<h4><b>2. Create and maintain complex models<\/b><\/h4>\n<p>Finance professionals can also use VBA to create trading, pricing, and risk management models. The models can be used to track the performance of stocks in the securities exchange market in real-time, forecast the trend of each stock, and provide signals on when to buy or sell and the appropriate pricing at each stage.<\/p>\n<p>The VBA program can also be used to generate financial ratios that allow analysts to evaluate the financial performance of publicly traded companies, as well as compare the trends and performance of two or more entities over a defined period of time.<\/p>\n<h4><b>3. Create investment scenarios<\/b><\/h4>\n<p>Investment bankers and financial analysts often need to make decisions by comparing two or more investment scenarios. For example, in\u00a0mergers and acquisitions, finance professionals must consider the financial impact of the merger to determine if it is feasible. The professionals can use VBA to create macros that simulate the investment scenarios to get an overview of the expected results\/effects.<\/p>\n<p>In such a way, it can eliminate human emotions that may interfere with the decision-making process and instead rely on a simulated analysis that is theoretically closer to reality. The decision-makers can make a decision based on the obtained results.<\/p>\n<h2 id=\"why-use-excel-vba\"><span class=\"ez-toc-section\" id=\"Why_use_Excel_VBA\"><\/span><strong>Why use Excel VBA?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>While users cannot directly manipulate the main Excel software through VBA, they can master the art of making macros to\u00a0optimize their time in Excel. There are two ways to make Excel macros.<\/p>\n<p>The first method is to use the Macro Recorder. After activating the recorder, Excel will record all the steps a user makes and save it as a \u201cprocess\u201d known as a macro. When the user ends the recorder, this macro is saved and can be assigned to a button that will run the exact same process again when clicked. This method is relatively simple and requires no inherent knowledge of the VBA code. This method will work for simple processes.<\/p>\n<p>However, the downfall of this method is that it is not very customizable, and the macro will mimic the user\u2019s input exactly. By default, recorder macros also use absolute referencing instead of relative referencing. It means that macros made in this way are very hard to use with\u00a0variables\u00a0and \u201csmart\u201d processes.<\/p>\n<p>The second and more powerful\u00a0method of creating an Excel macro is to code one using VBA.<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/entri.app\/course\/data-science-and-machine-learning-course\/\" target=\"_blank\" rel=\"noopener\"><strong>Learn Data Science from Expert Mentors! Get a free demo here!<\/strong><\/a><\/p>\n<h2 id=\"where-to-code-excel-vba\"><span class=\"ez-toc-section\" id=\"Where_to_code_Excel_VBA\"><\/span><strong>Where to code Excel VBA<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To access the VBA window, press Alt + F11 within any Office program. When done properly, this will open a window with a file structure tree on the top left, properties on the bottom left, a debug pane at the bottom center and bottom right, and the coding section that takes up the majority of the screen in the center and top right. This may seem overwhelming at first, but in reality, it\u2019s simpler than it appears.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1627 size-full\" src=\"https:\/\/cdn.corporatefinanceinstitute.com\/assets\/excel-vba.jpg\" srcset=\"\/\/cdn.corporatefinanceinstitute.com\/assets\/excel-vba.jpg 907w, \/\/cdn.corporatefinanceinstitute.com\/assets\/excel-vba-600x362.jpg 600w, \/\/cdn.corporatefinanceinstitute.com\/assets\/excel-vba-300x181.jpg 300w, \/\/cdn.corporatefinanceinstitute.com\/assets\/excel-vba-768x463.jpg 768w, \/\/cdn.corporatefinanceinstitute.com\/assets\/excel-vba-497x300.jpg 497w\" alt=\"Excel VBA example screenshot\" width=\"907\" height=\"547\" data-src=\"\" data-srcset=\"\/\/cdn.corporatefinanceinstitute.com\/assets\/excel-vba.jpg 907w, \/\/cdn.corporatefinanceinstitute.com\/assets\/excel-vba-600x362.jpg 600w, \/\/cdn.corporatefinanceinstitute.com\/assets\/excel-vba-300x181.jpg 300w, \/\/cdn.corporatefinanceinstitute.com\/assets\/excel-vba-768x463.jpg 768w, \/\/cdn.corporatefinanceinstitute.com\/assets\/excel-vba-497x300.jpg 497w\" data-sizes=\"(max-width: 907px) 100vw, 907px\" \/><\/p>\n<p>Most of the time, the user will be working in the coding section. The file structure section is only used for\u00a0creating a new macro file.\u00a0The properties section in the bottom left will only be used for more advanced macros that use UserForms to create graphical interfaces for the macro.<\/p>\n<p>The coding section is where most, if not all, of the coding happens. The user will create, code, and save macros here. After the macro code is written and saved, it can then be attached to certain triggers in the Excel model. The macro can be activated at the push of a specific button on the worksheet, or when certain cells are modified, for example. The easiest way to implement a macro is to attach it to a button.<\/p>\n<h2 id=\"vba-shortcuts-in-excel\"><span class=\"ez-toc-section\" id=\"VBA_shortcuts_in_Excel\"><\/span><strong>VBA shortcuts in Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The following are some of the shortcuts that work when using VBA in MS Excel:<\/p>\n<ul>\n<li><b>Alt + F11<\/b>: Open VBA Editor<\/li>\n<li><b>Alt + F8<\/b>: Display all macros<\/li>\n<li><b>Alt + F4<\/b>: Close VBA Editor and return to Excel<\/li>\n<li><b>F7<\/b>: Open code editor<\/li>\n<li><b>F1<\/b>: Display Help<\/li>\n<li><b>Ctrl + Space<\/b>: Autocomplete<\/li>\n<li><b>F10<\/b>: Activate menu bar<\/li>\n<li><b>Home<\/b>: Beginning of line<\/li>\n<li><b>Alt + F5<\/b>: Run Error Handler<\/li>\n<li><b>Alt + F6<\/b>: Switch between the last two windows<\/li>\n<li><b>Alt + F11<\/b>: Toggle between VBA Editor and Excel<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><a href=\"https:\/\/entri.app\/course\/data-science-and-machine-learning-course\/\" target=\"_blank\" rel=\"noopener\"><strong>Take your data science skills to the next level! Sign up for a free demo today!<\/strong><\/a><\/p>\n<div id=\"mntl-sc-block_1-0-77\" class=\"comp mntl-sc-block finance-sc-block-questionandanswer mntl-sc-block-questionandanswer\">\n<h2 class=\"mntl-sc-block-questionandanswer__question\"><span class=\"ez-toc-section\" id=\"What_Is_VBA_Used_for\"><\/span><strong>What Is VBA Used for?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div class=\"mntl-sc-block-questionandanswer__answer\">\n<p>VBA is used to further expand what some programs are able to accomplish. VBA is often used to create macros, automate processes, generate custom forms, or perform repetitive tasks that may need minimal human intervention.<\/p>\n<\/div>\n<\/div>\n<div id=\"mntl-sc-block_1-0-78\" class=\"comp mntl-sc-block mntl-sc-block-adslot mntl-block\"><strong style=\"color: #1d1f20; font-size: 1.953em;\">Is VBA the Same As Excel?<\/strong><\/div>\n<div id=\"mntl-sc-block_1-0-79\" class=\"comp mntl-sc-block finance-sc-block-questionandanswer mntl-sc-block-questionandanswer\">\n<div class=\"mntl-sc-block-questionandanswer__answer\">\n<p>VBA is a computer language that is used within Excel. While Excel is a broader software used for many different types of analytical functions, VBA enhances its capabilities.<\/p>\n<\/div>\n<\/div>\n<div id=\"mntl-sc-block_1-0-80\" class=\"comp mntl-sc-block mntl-sc-block-adslot mntl-block\"><strong style=\"color: #1d1f20; font-size: 1.953em;\">Is VBA Easy to Learn?<\/strong><\/div>\n<div id=\"mntl-sc-block_1-0-81\" class=\"comp mntl-sc-block finance-sc-block-questionandanswer mntl-sc-block-questionandanswer\">\n<div class=\"mntl-sc-block-questionandanswer__answer\">\n<p>Compared to other complex languages, VBA is relatively easier to learn. It is considered a beginner-friendly language, and VBA-coders often do not need to have prior experience as a coder to learn the language. In addition, the VBA community has many resources available for individuals new to programming.<\/p>\n<\/div>\n<\/div>\n<p id=\"mntl-sc-block_1-0-82\" class=\"comp mntl-sc-block mntl-sc-block-adslot mntl-block\"><strong><span style=\"color: #1d1f20; font-size: 1.953em;\">Is VBA Still In Demand?<\/span><\/strong><\/p>\n<div id=\"mntl-sc-block_1-0-83\" class=\"comp mntl-sc-block finance-sc-block-questionandanswer mntl-sc-block-questionandanswer\">\n<div class=\"mntl-sc-block-questionandanswer__answer\">\n<p>Yes, VBA is still useful and used by individuals interacting with Microsoft products. However, newer languages such as Python, C#, or R can be used to code in place of VBA. In addition, new tools such as Power Query may be able to perform tasks that could previously only be performed when using VBA.<\/p>\n<\/div>\n<\/div>\n<table class=\"table\">\n<tbody>\n<tr>\n<td colspan=\"2\" width=\"616\"><strong>Related links<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"308\"><a href=\"https:\/\/entri.app\/blog\/benefits-of-big-data\/\" target=\"_blank\" rel=\"noopener\"><strong>Top 10 Benefits of Big Data<\/strong><\/a><\/td>\n<td width=\"308\"><strong><a href=\"https:\/\/entri.app\/blog\/top-50-data-analyst-interview-questions\/\" target=\"_blank\" rel=\"noopener\">Top 50 Data Analyst Interview Questions<\/a><\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"308\"><strong><a href=\"https:\/\/entri.app\/blog\/how-to-become-a-data-analyst\/\" target=\"_blank\" rel=\"noopener\">How to Become a Data Analyst? Skills Required<\/a><\/strong><\/td>\n<td width=\"308\"><strong><a href=\"https:\/\/entri.app\/blog\/best-data-visualization-tools-list\/\" target=\"_blank\" rel=\"noopener\">Explore Best Data Visualization Tools List<\/a><\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"308\"><strong><a href=\"https:\/\/entri.app\/blog\/principal-component-analysis-in-machine-learning\/\" target=\"_blank\" rel=\"noopener\">Principal Component Analysis in Machine Learning<\/a><\/strong><\/td>\n<td width=\"308\"><strong><a href=\"https:\/\/entri.app\/blog\/data-engineer-roles\/\" target=\"_blank\" rel=\"noopener\">Data Engineer \u2013 Roles, Responsibilities and Skills Required<\/a><\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"308\"><strong><a href=\"https:\/\/entri.app\/blog\/data-wrangling-vs-data-cleaning-know-the-difference\/\" target=\"_blank\" rel=\"noopener\">Data Wrangling vs Data Cleaning \u2013 Know the Difference<\/a><\/strong><\/td>\n<td width=\"308\"><strong><a href=\"https:\/\/entri.app\/blog\/confusion-matrix-in-machine-learning\/\" target=\"_blank\" rel=\"noopener\">Confusion Matrix in Machine Learning<\/a><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>VBA is an abbreviation for Visual Basic for Application. VBA is a programming language that was developed by Microsoft Corp., and it is integrated into the major Microsoft Office applications, such as Word, Excel, and Access. The VBA programming language allows users to access functions beyond what is available in the MS Office applications. Users [&hellip;]<\/p>\n","protected":false},"author":111,"featured_media":25556545,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[802,1841],"tags":[],"class_list":["post-25556532","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-articles","category-entri-skilling"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>VBA in Excel - Definition, Examples, How to Use - Entri Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/entri.app\/blog\/vba-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA in Excel - Definition, Examples, How to Use - Entri Blog\" \/>\n<meta property=\"og:description\" content=\"VBA is an abbreviation for Visual Basic for Application. VBA is a programming language that was developed by Microsoft Corp., and it is integrated into the major Microsoft Office applications, such as Word, Excel, and Access. The VBA programming language allows users to access functions beyond what is available in the MS Office applications. Users [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/entri.app\/blog\/vba-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Entri Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/entri.me\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-17T07:07:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-21T08:29:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/VBA-in-Excel-Definition-Examples-How-to-Use.png\" \/>\n\t<meta property=\"og:image:width\" content=\"820\" \/>\n\t<meta property=\"og:image:height\" content=\"615\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Feeba Mahin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@entri_app\" \/>\n<meta name=\"twitter:site\" content=\"@entri_app\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Feeba Mahin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/entri.app\/blog\/vba-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/entri.app\/blog\/vba-in-excel\/\"},\"author\":{\"name\":\"Feeba Mahin\",\"@id\":\"https:\/\/entri.app\/blog\/#\/schema\/person\/f036dab84abae3dcc9390a1110d95d36\"},\"headline\":\"VBA in Excel &#8211; Definition, Examples, How to Use\",\"datePublished\":\"2023-03-17T07:07:16+00:00\",\"dateModified\":\"2023-03-21T08:29:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/entri.app\/blog\/vba-in-excel\/\"},\"wordCount\":2229,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/entri.app\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/entri.app\/blog\/vba-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/VBA-in-Excel-Definition-Examples-How-to-Use.png\",\"articleSection\":[\"Articles\",\"Entri Skilling\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/entri.app\/blog\/vba-in-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/entri.app\/blog\/vba-in-excel\/\",\"url\":\"https:\/\/entri.app\/blog\/vba-in-excel\/\",\"name\":\"VBA in Excel - Definition, Examples, How to Use - Entri Blog\",\"isPartOf\":{\"@id\":\"https:\/\/entri.app\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/entri.app\/blog\/vba-in-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/entri.app\/blog\/vba-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/VBA-in-Excel-Definition-Examples-How-to-Use.png\",\"datePublished\":\"2023-03-17T07:07:16+00:00\",\"dateModified\":\"2023-03-21T08:29:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/entri.app\/blog\/vba-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/entri.app\/blog\/vba-in-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/entri.app\/blog\/vba-in-excel\/#primaryimage\",\"url\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/VBA-in-Excel-Definition-Examples-How-to-Use.png\",\"contentUrl\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/VBA-in-Excel-Definition-Examples-How-to-Use.png\",\"width\":820,\"height\":615,\"caption\":\"VBA in Excel - Definition, Examples, How to Use\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/entri.app\/blog\/vba-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/entri.app\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Entri Skilling\",\"item\":\"https:\/\/entri.app\/blog\/category\/entri-skilling\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"VBA in Excel &#8211; Definition, Examples, How to Use\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/entri.app\/blog\/#website\",\"url\":\"https:\/\/entri.app\/blog\/\",\"name\":\"Entri Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/entri.app\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/entri.app\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/entri.app\/blog\/#organization\",\"name\":\"Entri App\",\"url\":\"https:\/\/entri.app\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/entri.app\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2019\/10\/Entri-Logo-1.png\",\"contentUrl\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2019\/10\/Entri-Logo-1.png\",\"width\":989,\"height\":446,\"caption\":\"Entri App\"},\"image\":{\"@id\":\"https:\/\/entri.app\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/entri.me\/\",\"https:\/\/x.com\/entri_app\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/entri.app\/blog\/#\/schema\/person\/f036dab84abae3dcc9390a1110d95d36\",\"name\":\"Feeba Mahin\",\"url\":\"https:\/\/entri.app\/blog\/author\/feeba123\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"VBA in Excel - Definition, Examples, How to Use - Entri Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/entri.app\/blog\/vba-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"VBA in Excel - Definition, Examples, How to Use - Entri Blog","og_description":"VBA is an abbreviation for Visual Basic for Application. VBA is a programming language that was developed by Microsoft Corp., and it is integrated into the major Microsoft Office applications, such as Word, Excel, and Access. The VBA programming language allows users to access functions beyond what is available in the MS Office applications. Users [&hellip;]","og_url":"https:\/\/entri.app\/blog\/vba-in-excel\/","og_site_name":"Entri Blog","article_publisher":"https:\/\/www.facebook.com\/entri.me\/","article_published_time":"2023-03-17T07:07:16+00:00","article_modified_time":"2023-03-21T08:29:00+00:00","og_image":[{"width":820,"height":615,"url":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/VBA-in-Excel-Definition-Examples-How-to-Use.png","type":"image\/png"}],"author":"Feeba Mahin","twitter_card":"summary_large_image","twitter_creator":"@entri_app","twitter_site":"@entri_app","twitter_misc":{"Written by":"Feeba Mahin","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/entri.app\/blog\/vba-in-excel\/#article","isPartOf":{"@id":"https:\/\/entri.app\/blog\/vba-in-excel\/"},"author":{"name":"Feeba Mahin","@id":"https:\/\/entri.app\/blog\/#\/schema\/person\/f036dab84abae3dcc9390a1110d95d36"},"headline":"VBA in Excel &#8211; Definition, Examples, How to Use","datePublished":"2023-03-17T07:07:16+00:00","dateModified":"2023-03-21T08:29:00+00:00","mainEntityOfPage":{"@id":"https:\/\/entri.app\/blog\/vba-in-excel\/"},"wordCount":2229,"commentCount":0,"publisher":{"@id":"https:\/\/entri.app\/blog\/#organization"},"image":{"@id":"https:\/\/entri.app\/blog\/vba-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/VBA-in-Excel-Definition-Examples-How-to-Use.png","articleSection":["Articles","Entri Skilling"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/entri.app\/blog\/vba-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/entri.app\/blog\/vba-in-excel\/","url":"https:\/\/entri.app\/blog\/vba-in-excel\/","name":"VBA in Excel - Definition, Examples, How to Use - Entri Blog","isPartOf":{"@id":"https:\/\/entri.app\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/entri.app\/blog\/vba-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/entri.app\/blog\/vba-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/VBA-in-Excel-Definition-Examples-How-to-Use.png","datePublished":"2023-03-17T07:07:16+00:00","dateModified":"2023-03-21T08:29:00+00:00","breadcrumb":{"@id":"https:\/\/entri.app\/blog\/vba-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/entri.app\/blog\/vba-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/entri.app\/blog\/vba-in-excel\/#primaryimage","url":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/VBA-in-Excel-Definition-Examples-How-to-Use.png","contentUrl":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/VBA-in-Excel-Definition-Examples-How-to-Use.png","width":820,"height":615,"caption":"VBA in Excel - Definition, Examples, How to Use"},{"@type":"BreadcrumbList","@id":"https:\/\/entri.app\/blog\/vba-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/entri.app\/blog\/"},{"@type":"ListItem","position":2,"name":"Entri Skilling","item":"https:\/\/entri.app\/blog\/category\/entri-skilling\/"},{"@type":"ListItem","position":3,"name":"VBA in Excel &#8211; Definition, Examples, How to Use"}]},{"@type":"WebSite","@id":"https:\/\/entri.app\/blog\/#website","url":"https:\/\/entri.app\/blog\/","name":"Entri Blog","description":"","publisher":{"@id":"https:\/\/entri.app\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/entri.app\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/entri.app\/blog\/#organization","name":"Entri App","url":"https:\/\/entri.app\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/entri.app\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2019\/10\/Entri-Logo-1.png","contentUrl":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2019\/10\/Entri-Logo-1.png","width":989,"height":446,"caption":"Entri App"},"image":{"@id":"https:\/\/entri.app\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/entri.me\/","https:\/\/x.com\/entri_app"]},{"@type":"Person","@id":"https:\/\/entri.app\/blog\/#\/schema\/person\/f036dab84abae3dcc9390a1110d95d36","name":"Feeba Mahin","url":"https:\/\/entri.app\/blog\/author\/feeba123\/"}]}},"_links":{"self":[{"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/posts\/25556532","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/users\/111"}],"replies":[{"embeddable":true,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/comments?post=25556532"}],"version-history":[{"count":4,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/posts\/25556532\/revisions"}],"predecessor-version":[{"id":25556839,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/posts\/25556532\/revisions\/25556839"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/media\/25556545"}],"wp:attachment":[{"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/media?parent=25556532"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/categories?post=25556532"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/tags?post=25556532"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}