{"id":24717,"date":"2020-02-21T00:26:12","date_gmt":"2020-02-20T18:56:12","guid":{"rendered":"https:\/\/mywindowshub.com\/?p=24717"},"modified":"2020-02-21T00:29:11","modified_gmt":"2020-02-20T18:59:11","slug":"how-to-launch-excel-vba-editor-interface-in-ms-excel","status":"publish","type":"post","link":"https:\/\/mywindowshub.com\/how-to-launch-excel-vba-editor-interface-in-ms-excel\/","title":{"rendered":"How To Launch Excel VBA Editor Interface In MS Excel?"},"content":{"rendered":"\n<p>Excel VBA is an amazing user friendly object oriented programming, which has gained popularity in a very short span of time. Any user, who does not have idea on coding can create Macro object, by simply recording the macros. There is a method of recording a macro, which we have already covered. Check the link at the bottom of the article, to find the list of some articles, which we have created so far. <\/p>\n\n\n\n<p>Users who love to code, can write VBA codes in the <strong>Visual Basic <\/strong>editor. The editor has these main components, as shown in the image below.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/img.mywindowshub.com\/images9\/visualbasic-5.jpg\" alt=\"Excel VBA Editor Interface In MS Excel\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Steps To Launch Excel VBA Editor Interface In MS Excel<\/h2>\n\n\n\n<p> First, you have to <a rel=\"noreferrer noopener\" href=\"https:\/\/mywindowshub.com\/how-to-turn-on-the-developer-tab-in-ms-excel-for-vba\/\" target=\"_blank\">turn on the Developer Tab in MS Excel<\/a>.  <\/p>\n\n\n\n<p>Now, go to the <strong>Developer <\/strong>tab. In the extreme left, you will find <strong>Visual Basic<\/strong> option. Click on it to open the Visual basic Editor. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/img.mywindowshub.com\/images9\/visualbasic-1.jpg\" alt=\"Excel VBA Editor Interface In MS Excel\"\/><\/figure>\n\n\n\n<p>The <strong>Visual Basic Editor<\/strong> for the Workbook opens. It will be better, if you reaize the window and set it in the right side, so that you get visibility to both the workbook and the code editor. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/img.mywindowshub.com\/images9\/visualbasic-2.jpg\" alt=\"Excel VBA Editor Interface In MS Excel\"\/><\/figure>\n\n\n\n<p>Next, have a look at the editor. As mentioned before, you need to check out if the <strong>Project Explorer<\/strong> window has a Module folder, the <strong>Properties<\/strong> window is open, the <strong>Immediate<\/strong> and <strong>Code<\/strong> windows are also opened. So, if it is a new workbook, and you have not yet created any Macro, then there will be <strong>no Module folder<\/strong> in the Project explorer. Go to <strong>Insert<\/strong> menu from the toolbar, and click on <strong>Module<\/strong>. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/img.mywindowshub.com\/images9\/visualbasic-3.jpg\" alt=\"Excel VBA Editor Interface In MS Excel\"\/><\/figure>\n\n\n\n<p>As you can see, there is an <strong>Immediate <\/strong>window. If it is not opened, then go to <strong>View <\/strong> option from the toolbar and select <strong>Immediate.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/img.mywindowshub.com\/images9\/visualbasic-4.jpg\" alt=\"Excel VBA Editor Interface In MS Excel\"\/><\/figure>\n\n\n\n<p>Now, you can start writing your codes and create Macros. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Read More: <a href=\"https:\/\/mywindowshub.com\/list-of-all-excel-vba-tutorials-in-mywindowshub-com\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"List Of All Excel VBA Tutorials (opens in a new tab)\">List Of All Excel VBA Tutorials<\/a><\/h3>\n","protected":false},"excerpt":{"rendered":"<p>Excel VBA is an amazing user friendly object oriented programming, which has gained popularity in a very short span of time. Any user, who does not have idea on coding can create Macro object, by simply recording the macros. There is a method of recording a macro, which we have already covered. Check the link [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":24745,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[254],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Launch Excel VBA Editor Interface In MS Excel? | MyWindowsHub<\/title>\n<meta name=\"description\" content=\"Excel VBA is an amazing user friendly object oriented programming, which has gained popularity in a very short span of time. Any user, who does not have idea on coding can create Macro object, by simply recording the macros.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/mywindowshub.com\/how-to-launch-excel-vba-editor-interface-in-ms-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Launch Excel VBA Editor Interface In MS Excel? | MyWindowsHub\" \/>\n<meta property=\"og:description\" content=\"Excel VBA is an amazing user friendly object oriented programming, which has gained popularity in a very short span of time. Any user, who does not have idea on coding can create Macro object, by simply recording the macros.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/mywindowshub.com\/how-to-launch-excel-vba-editor-interface-in-ms-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"My Windows Hub\" \/>\n<meta property=\"article:published_time\" content=\"2020-02-20T18:56:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-02-20T18:59:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/mywindowshub.com\/wp-content\/uploads\/2020\/02\/visualbasic-5.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1001\" \/>\n\t<meta property=\"og:image:height\" content=\"949\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Debaleena\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Debaleena\" \/>\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:\/\/mywindowshub.com\/how-to-launch-excel-vba-editor-interface-in-ms-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/mywindowshub.com\/how-to-launch-excel-vba-editor-interface-in-ms-excel\/\"},\"author\":{\"name\":\"Debaleena\",\"@id\":\"https:\/\/mywindowshub.com\/#\/schema\/person\/76bca69fe3d6504d9b8d96948af6cd44\"},\"headline\":\"How To Launch Excel VBA Editor Interface In MS Excel?\",\"datePublished\":\"2020-02-20T18:56:12+00:00\",\"dateModified\":\"2020-02-20T18:59:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/mywindowshub.com\/how-to-launch-excel-vba-editor-interface-in-ms-excel\/\"},\"wordCount\":311,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/mywindowshub.com\/#organization\"},\"articleSection\":[\"VBA For Office\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/mywindowshub.com\/how-to-launch-excel-vba-editor-interface-in-ms-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/mywindowshub.com\/how-to-launch-excel-vba-editor-interface-in-ms-excel\/\",\"url\":\"https:\/\/mywindowshub.com\/how-to-launch-excel-vba-editor-interface-in-ms-excel\/\",\"name\":\"How To Launch Excel VBA Editor Interface In MS Excel? | MyWindowsHub\",\"isPartOf\":{\"@id\":\"https:\/\/mywindowshub.com\/#website\"},\"datePublished\":\"2020-02-20T18:56:12+00:00\",\"dateModified\":\"2020-02-20T18:59:11+00:00\",\"description\":\"Excel VBA is an amazing user friendly object oriented programming, which has gained popularity in a very short span of time. Any user, who does not have idea on coding can create Macro object, by simply recording the macros.\",\"breadcrumb\":{\"@id\":\"https:\/\/mywindowshub.com\/how-to-launch-excel-vba-editor-interface-in-ms-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/mywindowshub.com\/how-to-launch-excel-vba-editor-interface-in-ms-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/mywindowshub.com\/how-to-launch-excel-vba-editor-interface-in-ms-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/mywindowshub.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Launch Excel VBA Editor Interface In MS Excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/mywindowshub.com\/#website\",\"url\":\"https:\/\/mywindowshub.com\/\",\"name\":\"My Windows Hub\",\"description\":\"Windows tutorials, themes, news and updates\",\"publisher\":{\"@id\":\"https:\/\/mywindowshub.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/mywindowshub.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/mywindowshub.com\/#organization\",\"name\":\"mywindowshub.com\",\"url\":\"https:\/\/mywindowshub.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/mywindowshub.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/mywindowshub.com\/wp-content\/uploads\/2018\/07\/mywindows.png\",\"contentUrl\":\"https:\/\/mywindowshub.com\/wp-content\/uploads\/2018\/07\/mywindows.png\",\"width\":494,\"height\":149,\"caption\":\"mywindowshub.com\"},\"image\":{\"@id\":\"https:\/\/mywindowshub.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/mywindowshub.com\/#\/schema\/person\/76bca69fe3d6504d9b8d96948af6cd44\",\"name\":\"Debaleena\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/mywindowshub.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/14adf9a60a4ffb992db2776601951629?s=96&d=wavatar&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/14adf9a60a4ffb992db2776601951629?s=96&d=wavatar&r=g\",\"caption\":\"Debaleena\"},\"description\":\"Happiness is that best therapy. Use it to heal yourself and then others!\",\"sameAs\":[\"http:\/\/warbleoflife.blogspot.in\/\"],\"url\":\"https:\/\/mywindowshub.com\/author\/debaleena\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Launch Excel VBA Editor Interface In MS Excel? | MyWindowsHub","description":"Excel VBA is an amazing user friendly object oriented programming, which has gained popularity in a very short span of time. Any user, who does not have idea on coding can create Macro object, by simply recording the macros.","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:\/\/mywindowshub.com\/how-to-launch-excel-vba-editor-interface-in-ms-excel\/","og_locale":"en_US","og_type":"article","og_title":"How To Launch Excel VBA Editor Interface In MS Excel? | MyWindowsHub","og_description":"Excel VBA is an amazing user friendly object oriented programming, which has gained popularity in a very short span of time. Any user, who does not have idea on coding can create Macro object, by simply recording the macros.","og_url":"https:\/\/mywindowshub.com\/how-to-launch-excel-vba-editor-interface-in-ms-excel\/","og_site_name":"My Windows Hub","article_published_time":"2020-02-20T18:56:12+00:00","article_modified_time":"2020-02-20T18:59:11+00:00","og_image":[{"width":1001,"height":949,"url":"https:\/\/mywindowshub.com\/wp-content\/uploads\/2020\/02\/visualbasic-5.png","type":"image\/png"}],"author":"Debaleena","twitter_misc":{"Written by":"Debaleena","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/mywindowshub.com\/how-to-launch-excel-vba-editor-interface-in-ms-excel\/#article","isPartOf":{"@id":"https:\/\/mywindowshub.com\/how-to-launch-excel-vba-editor-interface-in-ms-excel\/"},"author":{"name":"Debaleena","@id":"https:\/\/mywindowshub.com\/#\/schema\/person\/76bca69fe3d6504d9b8d96948af6cd44"},"headline":"How To Launch Excel VBA Editor Interface In MS Excel?","datePublished":"2020-02-20T18:56:12+00:00","dateModified":"2020-02-20T18:59:11+00:00","mainEntityOfPage":{"@id":"https:\/\/mywindowshub.com\/how-to-launch-excel-vba-editor-interface-in-ms-excel\/"},"wordCount":311,"commentCount":0,"publisher":{"@id":"https:\/\/mywindowshub.com\/#organization"},"articleSection":["VBA For Office"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/mywindowshub.com\/how-to-launch-excel-vba-editor-interface-in-ms-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/mywindowshub.com\/how-to-launch-excel-vba-editor-interface-in-ms-excel\/","url":"https:\/\/mywindowshub.com\/how-to-launch-excel-vba-editor-interface-in-ms-excel\/","name":"How To Launch Excel VBA Editor Interface In MS Excel? | MyWindowsHub","isPartOf":{"@id":"https:\/\/mywindowshub.com\/#website"},"datePublished":"2020-02-20T18:56:12+00:00","dateModified":"2020-02-20T18:59:11+00:00","description":"Excel VBA is an amazing user friendly object oriented programming, which has gained popularity in a very short span of time. Any user, who does not have idea on coding can create Macro object, by simply recording the macros.","breadcrumb":{"@id":"https:\/\/mywindowshub.com\/how-to-launch-excel-vba-editor-interface-in-ms-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/mywindowshub.com\/how-to-launch-excel-vba-editor-interface-in-ms-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/mywindowshub.com\/how-to-launch-excel-vba-editor-interface-in-ms-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/mywindowshub.com\/"},{"@type":"ListItem","position":2,"name":"How To Launch Excel VBA Editor Interface In MS Excel?"}]},{"@type":"WebSite","@id":"https:\/\/mywindowshub.com\/#website","url":"https:\/\/mywindowshub.com\/","name":"My Windows Hub","description":"Windows tutorials, themes, news and updates","publisher":{"@id":"https:\/\/mywindowshub.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/mywindowshub.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/mywindowshub.com\/#organization","name":"mywindowshub.com","url":"https:\/\/mywindowshub.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/mywindowshub.com\/#\/schema\/logo\/image\/","url":"https:\/\/mywindowshub.com\/wp-content\/uploads\/2018\/07\/mywindows.png","contentUrl":"https:\/\/mywindowshub.com\/wp-content\/uploads\/2018\/07\/mywindows.png","width":494,"height":149,"caption":"mywindowshub.com"},"image":{"@id":"https:\/\/mywindowshub.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/mywindowshub.com\/#\/schema\/person\/76bca69fe3d6504d9b8d96948af6cd44","name":"Debaleena","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/mywindowshub.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/14adf9a60a4ffb992db2776601951629?s=96&d=wavatar&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/14adf9a60a4ffb992db2776601951629?s=96&d=wavatar&r=g","caption":"Debaleena"},"description":"Happiness is that best therapy. Use it to heal yourself and then others!","sameAs":["http:\/\/warbleoflife.blogspot.in\/"],"url":"https:\/\/mywindowshub.com\/author\/debaleena\/"}]}},"_links":{"self":[{"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/posts\/24717"}],"collection":[{"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/comments?post=24717"}],"version-history":[{"count":9,"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/posts\/24717\/revisions"}],"predecessor-version":[{"id":24744,"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/posts\/24717\/revisions\/24744"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/media\/24745"}],"wp:attachment":[{"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/media?parent=24717"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/categories?post=24717"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/tags?post=24717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}