{"id":834,"date":"2013-11-16T14:55:07","date_gmt":"2013-11-16T14:55:07","guid":{"rendered":"http:\/\/excelvbatutor.com\/?page_id=834"},"modified":"2019-04-19T07:30:29","modified_gmt":"2019-04-19T07:30:29","slug":"excel-vba-2010-tutorial-lesson-1-introduction-to-excel-vba-2010-editor","status":"publish","type":"page","link":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-tutorial-lesson-1-introduction-to-excel-vba-2010-editor\/","title":{"rendered":"Excel 2010 VBA Lesson 1:  Excel  VBA  Editor"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\"><strong><a title=\"excel vba 2010 tutorial\" href=\"http:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-tutorial\/\">[Table of Contents]<\/a>&gt;&gt;<a href=\"http:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-2-data-types-constants-and-variables\/\">[Lesson 2]<\/a><\/strong><\/h4>\n\n\n\n<p>Microsoft 2010 Excel&nbsp; looks similar to Microsoft Excel 2007 but both are considerably different from Microsoft Excel 2003. MS Excel 2010 employs interactive ribbon controls for the menu bar instead of the old menu structure. Fortunately, the Visual Basic Editor (VBE) remains largely the same as that of version 2003.<br>\n<script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br>\n<ins class=\"adsbygoogle\" style=\"display:block; text-align:center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-3033628290023372\" data-ad-slot=\"9639157585\"><\/ins><br>\n<script><br \/>\n     (adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n\n\n\n<p>However, finding the active-x controls on the ribbon control is not as obvious as in Microsoft Excel 2003. You need to locate the Developer tab and click on it to launch the Excel 2010 VBA&nbsp; project window, as shown in Figure 1.1.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/11\/vba2010_fig1.14.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"885\" height=\"486\" src=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/11\/vba2010_fig1.14.jpg\" alt=\"vba2010_fig1.1\" class=\"wp-image-846\"\/><\/a><\/figure><\/div>\n\n\n\n<p><strong>Figure 1.1<\/strong><\/p>\n\n\n\n<div>\n<p><script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br>\n<ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-3033628290023372\" data-ad-slot=\"9639157585\"><\/ins><br>\n<script><br \/>\n     (adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n<\/div>\n\n\n\n<p>Sometimes the Developer tab is not shown on the menu bar. What should you do then? You have to open the Excel Options dialog by clicking File and then select options. The Excel Options dialog is as shown in Figure 1.2:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/11\/vba2010_fig1.2.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"840\" height=\"685\" src=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/11\/vba2010_fig1.2.jpg\" alt=\"vba2010_fig1.2\" class=\"wp-image-828\"\/><\/a><\/figure><\/div>\n\n\n\n<p><br>\n<strong>Figure 1.2<\/strong><\/p>\n\n\n\n<p>In the Excel Options window, select customize ribbons and you can see the following dialog box, make sure you check the Developer option, as shown in Figure 1.3:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/11\/vba2010_fig1.3.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"840\" height=\"685\" src=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/11\/vba2010_fig1.3.jpg\" alt=\"vba2010_fig1.3\" class=\"wp-image-830\"\/><\/a><\/figure><\/div>\n\n\n\n<p><strong>Figure 1.3: Excel Options<\/strong><\/p>\n\n\n\n<div>\n<p><script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br>\n<ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-3033628290023372\" data-ad-slot=\"9639157585\"><\/ins><br>\n<script><br \/>\n     (adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n<\/div>\n\n\n\n<p>After clicking on the Developer tab, you will be presented with the Developer window when you can have access to the &nbsp;Excel 2010&nbsp; VBA&nbsp; editor &nbsp;as well as recording macros and more, as shown below:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/11\/vba2010_fig1.4.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"865\" height=\"522\" src=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/11\/vba2010_fig1.4.jpg\" alt=\"vba2010_fig1.4\" class=\"wp-image-847\"\/><\/a><\/figure><\/div>\n\n\n\n<p><strong>Figure 1.4: The developer window<\/strong><\/p>\n\n\n\n<p>Clicking on View Code will launch the Excel 2010 VBA&nbsp; Editor Code Window.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/11\/vba2010_fig1.5.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1038\" height=\"612\" src=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/11\/vba2010_fig1.5.jpg\" alt=\"vba2010_fig1.5\" class=\"wp-image-851\"\/><\/a><\/figure><\/div>\n\n\n\n<p><strong>Figure 1.5: The Excel 2010 VBA &nbsp;Editor<\/strong><\/p>\n\n\n\n<p>Now select Sheet1 in the VBA objects explorer window on the far left and the Book1-Sheet1 windows appears. Enter the following statements in the sheet 1 code window:\n<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Private Sub Worksheet_Activate()\n MsgBox \"Welcome to Excel VBA 2010\"\nEnd Sub\n<\/pre>\n\n\n\n<p>As shown in Figure 1.6<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/11\/vba2010_fig1.6.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"895\" height=\"449\" src=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/11\/vba2010_fig1.6.jpg\" alt=\"vba2010_fig1.6\" class=\"wp-image-860\"\/><\/a><\/figure><\/div>\n\n\n\n<p>Whenever the user clicks on worksheet 1, the following message box will pop out:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/11\/vba2010_fig1.7.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"210\" height=\"155\" src=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/11\/vba2010_fig1.7.jpg\" alt=\"vba2010_fig1.7\" class=\"wp-image-861\"\/><\/a><\/figure><\/div>\n\n\n\n<div>\n<p><script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br>\n<ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-3033628290023372\" data-ad-slot=\"9639157585\"><\/ins><br>\n<script><br \/>\n     (adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n<\/div>\n\n\n\n<h4 class=\"wp-block-heading\"><strong><a href=\"http:\/\/excelvbatutor.com\/index.php\/exccel-vba-2010-tutorial\/\">[Table of Contents]<\/a>&gt;&gt;<a href=\"http:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-2-data-types-constants-and-variables\/\">[Lesson 2]<\/a><\/strong><\/h4>\n","protected":false},"excerpt":{"rendered":"<p>[Table of Contents]&gt;&gt;[Lesson 2] Microsoft 2010 Excel&nbsp; looks similar to Microsoft Excel 2007 but both are considerably different from Microsoft Excel 2003. MS Excel 2010 employs interactive ribbon controls for the menu bar instead of the old menu structure. Fortunately, the Visual Basic Editor (VBE) remains largely the same as that of version 2003. However, &hellip; <a href=\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-tutorial-lesson-1-introduction-to-excel-vba-2010-editor\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Excel 2010 VBA Lesson 1:  Excel  VBA  Editor&#8221;<\/span><\/a><\/p>\n","protected":false},"author":5012,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[21],"tags":[],"class_list":["post-834","page","type-page","status-publish","hentry","category-editor"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel 2010 VBA Lesson 1: Excel VBA Editor - Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor<\/title>\n<meta name=\"description\" content=\"This lesson introduces Excel 2010 VBA Editor\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-tutorial-lesson-1-introduction-to-excel-vba-2010-editor\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel 2010 VBA Lesson 1: Excel VBA Editor - Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor\" \/>\n<meta property=\"og:description\" content=\"This lesson introduces Excel 2010 VBA Editor\" \/>\n<meta property=\"og:url\" content=\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-tutorial-lesson-1-introduction-to-excel-vba-2010-editor\/\" \/>\n<meta property=\"og:site_name\" content=\"Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor\" \/>\n<meta property=\"article:modified_time\" content=\"2019-04-19T07:30:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/11\/vba2010_fig1.14.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"885\" \/>\n\t<meta property=\"og:image:height\" content=\"486\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-tutorial-lesson-1-introduction-to-excel-vba-2010-editor\/\",\"url\":\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-tutorial-lesson-1-introduction-to-excel-vba-2010-editor\/\",\"name\":\"Excel 2010 VBA Lesson 1: Excel VBA Editor - Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor\",\"isPartOf\":{\"@id\":\"https:\/\/excelvbatutor.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-tutorial-lesson-1-introduction-to-excel-vba-2010-editor\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-tutorial-lesson-1-introduction-to-excel-vba-2010-editor\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/11\/vba2010_fig1.14.jpg\",\"datePublished\":\"2013-11-16T14:55:07+00:00\",\"dateModified\":\"2019-04-19T07:30:29+00:00\",\"description\":\"This lesson introduces Excel 2010 VBA Editor\",\"breadcrumb\":{\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-tutorial-lesson-1-introduction-to-excel-vba-2010-editor\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-tutorial-lesson-1-introduction-to-excel-vba-2010-editor\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-tutorial-lesson-1-introduction-to-excel-vba-2010-editor\/#primaryimage\",\"url\":\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/11\/vba2010_fig1.14.jpg\",\"contentUrl\":\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/11\/vba2010_fig1.14.jpg\",\"width\":885,\"height\":486},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-tutorial-lesson-1-introduction-to-excel-vba-2010-editor\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/excelvbatutor.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel 2010 VBA Lesson 1: Excel VBA Editor\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/excelvbatutor.com\/#website\",\"url\":\"https:\/\/excelvbatutor.com\/\",\"name\":\"Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor\",\"description\":\"Master Excel VBA with free tutorials, examples, and personalized guidance. Perfect for beginners and advanced users looking to automate Excel.\",\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel 2010 VBA Lesson 1: Excel VBA Editor - Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor","description":"This lesson introduces Excel 2010 VBA Editor","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:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-tutorial-lesson-1-introduction-to-excel-vba-2010-editor\/","og_locale":"en_US","og_type":"article","og_title":"Excel 2010 VBA Lesson 1: Excel VBA Editor - Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor","og_description":"This lesson introduces Excel 2010 VBA Editor","og_url":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-tutorial-lesson-1-introduction-to-excel-vba-2010-editor\/","og_site_name":"Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor","article_modified_time":"2019-04-19T07:30:29+00:00","og_image":[{"width":885,"height":486,"url":"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/11\/vba2010_fig1.14.jpg","type":"image\/jpeg"}],"twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-tutorial-lesson-1-introduction-to-excel-vba-2010-editor\/","url":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-tutorial-lesson-1-introduction-to-excel-vba-2010-editor\/","name":"Excel 2010 VBA Lesson 1: Excel VBA Editor - Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor","isPartOf":{"@id":"https:\/\/excelvbatutor.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-tutorial-lesson-1-introduction-to-excel-vba-2010-editor\/#primaryimage"},"image":{"@id":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-tutorial-lesson-1-introduction-to-excel-vba-2010-editor\/#primaryimage"},"thumbnailUrl":"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/11\/vba2010_fig1.14.jpg","datePublished":"2013-11-16T14:55:07+00:00","dateModified":"2019-04-19T07:30:29+00:00","description":"This lesson introduces Excel 2010 VBA Editor","breadcrumb":{"@id":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-tutorial-lesson-1-introduction-to-excel-vba-2010-editor\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-tutorial-lesson-1-introduction-to-excel-vba-2010-editor\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-tutorial-lesson-1-introduction-to-excel-vba-2010-editor\/#primaryimage","url":"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/11\/vba2010_fig1.14.jpg","contentUrl":"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/11\/vba2010_fig1.14.jpg","width":885,"height":486},{"@type":"BreadcrumbList","@id":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-tutorial-lesson-1-introduction-to-excel-vba-2010-editor\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/excelvbatutor.com\/"},{"@type":"ListItem","position":2,"name":"Excel 2010 VBA Lesson 1: Excel VBA Editor"}]},{"@type":"WebSite","@id":"https:\/\/excelvbatutor.com\/#website","url":"https:\/\/excelvbatutor.com\/","name":"Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor","description":"Master Excel VBA with free tutorials, examples, and personalized guidance. Perfect for beginners and advanced users looking to automate Excel.","inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/pages\/834","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/users\/5012"}],"replies":[{"embeddable":true,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/comments?post=834"}],"version-history":[{"count":63,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/pages\/834\/revisions"}],"predecessor-version":[{"id":3315,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/pages\/834\/revisions\/3315"}],"wp:attachment":[{"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/media?parent=834"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/categories?post=834"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/tags?post=834"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}