{"id":495,"date":"2018-06-28T11:26:48","date_gmt":"2018-06-28T11:26:48","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=495"},"modified":"2024-03-30T10:48:32","modified_gmt":"2024-03-30T10:48:32","slug":"visual-basic-editor-vbe","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/training\/visual-basic-editor-vbe\/","title":{"rendered":"Visual Basic Editor (VBE)"},"content":{"rendered":"\n

VBE (which stands for Visual Basic Editor) is a separate application, integrated with Excel. Here, you can write or edit your macros.<\/p>\n\n\n\n

In order to open VBA, press\u00a0Alt + F11<\/span><\/strong>\u00a0or go to\u00a0DEVELOPER >> Code >> Visual Basic<\/strong>.<\/p>\n\n\n\n

\n

The\u00a0DEVELOPER<\/a>\u00a0tab is hidden by default. Check this lesson, to learn how to show it in the ribbon.<\/p>\nNOTICE<\/cite><\/blockquote>\n\n\n\n

A new window will open. It will most likely look different than the one below. You probably can\u2019t see the Immediate window<\/em>. If you want to show it, use the Ctrl + G<\/strong> keyboard shortcut or click View >> Immediate Window<\/strong> from the menu bar.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Menu bar<\/h3>\n\n\n\n

The ribbon<\/a> replaced the menu bar in Excel, but it is still present in VBE. Here, you can find commands that can be used to control various components in VBE. Additionally, you can control them by using keyboard shortcuts. Just use Alt + underlined character<\/strong> from the menu.<\/p>\n\n\n\n

Toolbar<\/h3>\n\n\n\n

In the Toolbar, you can find buttons to which you can have quick and easy access. For example running and stopping macros, switching back to Excel, saving the macro and more.<\/p>\n\n\n\n

Project window<\/h3>\n\n\n\n

This window shows the tree diagram with every workbook and its worksheets<\/a> that are currently opened. You can expand and collapse them by clicking the plus and minus signs.<\/p>\n\n\n\n

Code window<\/h3>\n\n\n\n

By default, this window is empty. Here, you can put your VBA code. In order to open this window double-click one of the objects in the Project window.<\/p>\n\n\n\n

Immediate window<\/h3>\n\n\n\n

This window is useful if you want to debug your code. You can hide it by clicking the \u201ex\u201d button in the upper right corner.<\/p>\n\n\n\n

Properties Window<\/h3>\n\n\n\n

As the name suggests it contains a list of properties that define this particular object.<\/p>\n\n\n\n

\n

There are even more windows in VBE than those presented in the image. Go to View or use the\u00a0Left Alt + V\u00a0<\/strong>shortcut to display them.<\/p>\nNOTICE<\/cite><\/blockquote>\n","protected":false},"excerpt":{"rendered":"

VBE (which stands for Visual Basic Editor) is a separate application, integrated with Excel. Here, you can write or edit your macros. In…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[188,190],"yoast_head":"\nVisual Basic Editor (VBE)<\/title>\n<meta name=\"description\" content=\"Learn how to access and use the Visual Basic Editor (VBE) in Excel to write and edit macros. Includes a breakdown of the menu and code windows, as well as tips for debugging.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/training\/visual-basic-editor-vbe\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Visual Basic Editor (VBE)\" \/>\n<meta property=\"og:description\" content=\"Learn how to access and use the Visual Basic Editor (VBE) in Excel to write and edit macros. Includes a breakdown of the menu and code windows, as well as tips for debugging.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/training\/visual-basic-editor-vbe\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-28T11:26:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-30T10:48:32+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/Visual_Basic_Editor.png\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/visual-basic-editor-vbe\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/visual-basic-editor-vbe\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Visual Basic Editor (VBE)\",\"datePublished\":\"2018-06-28T11:26:48+00:00\",\"dateModified\":\"2024-03-30T10:48:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/visual-basic-editor-vbe\/\"},\"wordCount\":327,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/visual-basic-editor-vbe\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/Visual_Basic_Editor.png\",\"keywords\":[\"added\",\"pinterest\"],\"articleSection\":[\"training\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/visual-basic-editor-vbe\/\",\"url\":\"https:\/\/officetuts.net\/excel\/training\/visual-basic-editor-vbe\/\",\"name\":\"Visual Basic Editor (VBE)\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/visual-basic-editor-vbe\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/visual-basic-editor-vbe\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/Visual_Basic_Editor.png\",\"datePublished\":\"2018-06-28T11:26:48+00:00\",\"dateModified\":\"2024-03-30T10:48:32+00:00\",\"description\":\"Learn how to access and use the Visual Basic Editor (VBE) in Excel to write and edit macros. Includes a breakdown of the menu and code windows, as well as tips for debugging.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/visual-basic-editor-vbe\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/training\/visual-basic-editor-vbe\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/visual-basic-editor-vbe\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/Visual_Basic_Editor.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/Visual_Basic_Editor.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/visual-basic-editor-vbe\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Visual Basic Editor (VBE)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Visual Basic Editor (VBE)","description":"Learn how to access and use the Visual Basic Editor (VBE) in Excel to write and edit macros. Includes a breakdown of the menu and code windows, as well as tips for debugging.","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:\/\/officetuts.net\/excel\/training\/visual-basic-editor-vbe\/","og_locale":"en_US","og_type":"article","og_title":"Visual Basic Editor (VBE)","og_description":"Learn how to access and use the Visual Basic Editor (VBE) in Excel to write and edit macros. Includes a breakdown of the menu and code windows, as well as tips for debugging.","og_url":"https:\/\/officetuts.net\/excel\/training\/visual-basic-editor-vbe\/","article_published_time":"2018-06-28T11:26:48+00:00","article_modified_time":"2024-03-30T10:48:32+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/Visual_Basic_Editor.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/training\/visual-basic-editor-vbe\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/training\/visual-basic-editor-vbe\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Visual Basic Editor (VBE)","datePublished":"2018-06-28T11:26:48+00:00","dateModified":"2024-03-30T10:48:32+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/training\/visual-basic-editor-vbe\/"},"wordCount":327,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/training\/visual-basic-editor-vbe\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/Visual_Basic_Editor.png","keywords":["added","pinterest"],"articleSection":["training"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/training\/visual-basic-editor-vbe\/","url":"https:\/\/officetuts.net\/excel\/training\/visual-basic-editor-vbe\/","name":"Visual Basic Editor (VBE)","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/training\/visual-basic-editor-vbe\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/training\/visual-basic-editor-vbe\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/Visual_Basic_Editor.png","datePublished":"2018-06-28T11:26:48+00:00","dateModified":"2024-03-30T10:48:32+00:00","description":"Learn how to access and use the Visual Basic Editor (VBE) in Excel to write and edit macros. Includes a breakdown of the menu and code windows, as well as tips for debugging.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/training\/visual-basic-editor-vbe\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/training\/visual-basic-editor-vbe\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/training\/visual-basic-editor-vbe\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/Visual_Basic_Editor.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/Visual_Basic_Editor.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/training\/visual-basic-editor-vbe\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Visual Basic Editor (VBE)"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/495"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=495"}],"version-history":[{"count":6,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/495\/revisions"}],"predecessor-version":[{"id":17270,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/495\/revisions\/17270"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=495"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=495"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=495"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}