{"appState":{"pageLoadApiCallsStatus":true},"articleState":{"article":{"headers":{"creationTime":"2018-09-11T19:20:48+00:00","modifiedTime":"2018-09-11T19:20:48+00:00","timestamp":"2022-09-14T18:16:45+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Microsoft Products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"},"slug":"microsoft-products","categoryId":33642},{"name":"Excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"},"slug":"excel","categoryId":33644}],"title":"Shortcut Keys for Working in the Visual Basic Editor Code Window","strippedTitle":"shortcut keys for working in the visual basic editor code window","slug":"shortcut-keys-for-working-in-the-visual-basic-editor-code-window","canonicalUrl":"","seo":{"metaDescription":"At some point, you may find yourself working with many macros at one time. It can be tedious trying to navigate between and within macro procedures by clicking ","noIndex":0,"noFollow":0},"content":"At some point, you may find yourself working with many macros at one time. It can be tedious trying to navigate between and within macro procedures by clicking around with the mouse. These keyboard shortcuts allow you to quickly jump to a target procedure, navigate modules, and even find the starting point for variables.\r\n<table>\r\n<tbody>\r\n<tr>\r\n<td width=\"169\">What to Press</td>\r\n<td width=\"469\">What It Does</td>\r\n</tr>\r\n<tr>\r\n<td width=\"169\">Ctrl+down arrow</td>\r\n<td width=\"469\">Selects the next procedure.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"169\">Ctrl+up arrow</td>\r\n<td width=\"469\">Selects the previous procedure.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"169\">Ctrl+Page Down</td>\r\n<td width=\"469\">Shifts one screen down.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"169\">Ctrl+Page Up</td>\r\n<td width=\"469\">Shifts one screen up.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"169\">Shift+F2</td>\r\n<td width=\"469\">Goes to the selected function or variable.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"169\">Ctrl+Shift+F2</td>\r\n<td width=\"469\">Goes to the last position.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"169\">Ctrl+Home</td>\r\n<td width=\"469\">Goes to the beginning of module.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"169\">Ctrl+End</td>\r\n<td width=\"469\">Goes to the end of module.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"169\">Ctrl+right arrow</td>\r\n<td width=\"469\">Moves one word to the right.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"169\">Ctrl+left arrow</td>\r\n<td width=\"469\">Moves one word to the left.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"169\">End</td>\r\n<td width=\"469\">Moves to the end of the line.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"169\">Home</td>\r\n<td width=\"469\">Moves to the beginning of the line.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"169\">Tab</td>\r\n<td width=\"469\">Indents the current line.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"169\">Shift+Tab</td>\r\n<td width=\"469\">Removes the indent for the current line.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"169\">Ctrl+J</td>\r\n<td width=\"469\">Lists the properties and methods for the selected object.</td>\r\n</tr>\r\n</tbody>\r\n</table>","description":"At some point, you may find yourself working with many macros at one time. It can be tedious trying to navigate between and within macro procedures by clicking around with the mouse. These keyboard shortcuts allow you to quickly jump to a target procedure, navigate modules, and even find the starting point for variables.\r\n<table>\r\n<tbody>\r\n<tr>\r\n<td width=\"169\">What to Press</td>\r\n<td width=\"469\">What It Does</td>\r\n</tr>\r\n<tr>\r\n<td width=\"169\">Ctrl+down arrow</td>\r\n<td width=\"469\">Selects the next procedure.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"169\">Ctrl+up arrow</td>\r\n<td width=\"469\">Selects the previous procedure.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"169\">Ctrl+Page Down</td>\r\n<td width=\"469\">Shifts one screen down.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"169\">Ctrl+Page Up</td>\r\n<td width=\"469\">Shifts one screen up.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"169\">Shift+F2</td>\r\n<td width=\"469\">Goes to the selected function or variable.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"169\">Ctrl+Shift+F2</td>\r\n<td width=\"469\">Goes to the last position.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"169\">Ctrl+Home</td>\r\n<td width=\"469\">Goes to the beginning of module.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"169\">Ctrl+End</td>\r\n<td width=\"469\">Goes to the end of module.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"169\">Ctrl+right arrow</td>\r\n<td width=\"469\">Moves one word to the right.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"169\">Ctrl+left arrow</td>\r\n<td width=\"469\">Moves one word to the left.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"169\">End</td>\r\n<td width=\"469\">Moves to the end of the line.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"169\">Home</td>\r\n<td width=\"469\">Moves to the beginning of the line.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"169\">Tab</td>\r\n<td width=\"469\">Indents the current line.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"169\">Shift+Tab</td>\r\n<td width=\"469\">Removes the indent for the current line.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"169\">Ctrl+J</td>\r\n<td width=\"469\">Lists the properties and methods for the selected object.</td>\r\n</tr>\r\n</tbody>\r\n</table>","blurb":"","authors":[{"authorId":9032,"name":"John Walkenbach","slug":"john-walkenbach","description":"","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9032"}}],"primaryCategoryTaxonomy":{"categoryId":33644,"title":"Excel","slug":"excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":259516,"title":"10 Resources for Excel VBA Help","slug":"10-resources-for-excel-vba-help","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259516"}},{"articleId":259511,"title":"Selecting an Excel VBA Range","slug":"selecting-an-excel-vba-range","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259511"}},{"articleId":259497,"title":"Naming Excel VBA Subs and Functions","slug":"naming-excel-vba-subs-and-functions","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259497"}},{"articleId":259491,"title":"Excel VBA Examples: Introductory Event Examples","slug":"excel-vba-examples-introductory-event-examples","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259491"}},{"articleId":259483,"title":"How to Use Excel’s Built-In VBA Functions","slug":"how-to-use-excels-built-in-vba-functions","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259483"}}],"fromCategory":[{"articleId":288828,"title":"Excel 2021 All-in-One For Dummies Cheat Sheet","slug":"excel-2021-all-in-one-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/288828"}},{"articleId":265521,"title":"How to Use the XLOOKUP Function in Excel 2016","slug":"how-to-use-the-xlookup-function-in-excel-2016","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265521"}},{"articleId":263475,"title":"Notes and File Sharing features in Excel 2016 Update","slug":"notes-and-coauthoring-features-in-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263475"}},{"articleId":263466,"title":"New Chart & Graphics features on Excel 2016 update","slug":"new-chart-graphics-features-on-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263466"}},{"articleId":263453,"title":"New Formulas and Functions in Excel 2016","slug":"how-to-use-new-formula-and-functions-in-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263453"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281715,"slug":"excel-vba-programming-for-dummies","isbn":"9781119843078","categoryList":["technology","software","microsoft-products","excel"],"amazon":{"default":"https://www.amazon.com/gp/product/1119843073/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119843073/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/1119843073-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119843073/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119843073/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/1119843073-203x255.jpg","width":203,"height":255},"title":"Excel VBA Programming For Dummies","testBankPinActivationLink":"","bookOutOfPrint":true,"authorsInfo":"<p> <b><b data-author-id=\"34673\">Dick Kusleika</b></b> has been helping users get the most out of Microsoft Office products for more than 25 years through online forums, blogging, books, and conferences.</p>","authors":[{"authorId":34673,"name":"Dick Kusleika","slug":"dick-kusleika","description":" <p> <b>Dick Kusleika</b> has been helping users get the most out of Microsoft Office products for more than 25 years through online forums, blogging, books, and conferences.</p> ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/34673"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{"key":"cat","values":["technology","software","microsoft-products","excel"]},{"key":"isbn","values":["9781119843078"]}]\" id=\"du-slot-63221a8da1776\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{"key":"cat","values":["technology","software","microsoft-products","excel"]},{"key":"isbn","values":["9781119843078"]}]\" id=\"du-slot-63221a8da2015\"></div></div>"},"articleType":{"articleType":"Articles","articleList":null,"content":null,"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0},"sponsorAd":"","sponsorEbookTitle":"","sponsorEbookLink":"","sponsorEbookImage":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":null,"lifeExpectancySetFrom":null,"dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":255374},"articleLoadedStatus":"success"},"listState":{"list":{},"objectTitle":"","status":"initial","pageType":null,"objectId":null,"page":1,"sortField":"time","sortOrder":1,"categoriesIds":[],"articleTypes":[],"filterData":{},"filterDataLoadedStatus":"initial","pageSize":10},"adsState":{"pageScripts":{"headers":{"timestamp":"2024-03-04T05:50:01+00:00"},"adsId":0,"data":{"scripts":[{"pages":["all"],"location":"header","script":"\r\n<script src=\"https://cdn.optimizely.com/js/10563184655.js\"></script>","enabled":false},{"pages":["all"],"location":"header","script":"\r\n<script>var _comscore = _comscore || [];_comscore.push({ c1: \"2\", c2: \"15097263\" });(function() {var s = document.createElement(\"script\"), el = document.getElementsByTagName(\"script\")[0]; s.async = true;s.src = (document.location.protocol == \"https:\" ? \"https://sb\" : \"http://b\") + \".scorecardresearch.com/beacon.js\";el.parentNode.insertBefore(s, el);})();</script><noscript><img src=\"https://sb.scorecardresearch.com/p?c1=2&c2=15097263&cv=2.0&cj=1\" /></noscript>\r\n","enabled":true},{"pages":["all"],"location":"footer","script":"\r\n<script type='text/javascript'>\r\n(function(){var g=function(e,h,f,g){\r\nthis.get=function(a){for(var a=a+\"=\",c=document.cookie.split(\";\"),b=0,e=c.length;b<e;b++){for(var d=c[b];\" \"==d.charAt(0);)d=d.substring(1,d.length);if(0==d.indexOf(a))return d.substring(a.length,d.length)}return null};\r\nthis.set=function(a,c){var b=\"\",b=new Date;b.setTime(b.getTime()+6048E5);b=\"; expires=\"+b.toGMTString();document.cookie=a+\"=\"+c+b+\"; path=/; \"};\r\nthis.check=function(){var a=this.get(f);if(a)a=a.split(\":\");else if(100!=e)\"v\"==h&&(e=Math.random()>=e/100?0:100),a=[h,e,0],this.set(f,a.join(\":\"));else return!0;var c=a[1];if(100==c)return!0;switch(a[0]){case \"v\":return!1;case \"r\":return c=a[2]%Math.floor(100/c),a[2]++,this.set(f,a.join(\":\")),!c}return!0};\r\nthis.go=function(){if(this.check()){var a=document.createElement(\"script\");a.type=\"text/javascript\";a.src=g;document.body&&document.body.appendChild(a)}};\r\nthis.start=function(){var t=this;\"complete\"!==document.readyState?window.addEventListener?window.addEventListener(\"load\",function(){t.go()},!1):window.attachEvent&&window.attachEvent(\"onload\",function(){t.go()}):t.go()};};\r\ntry{(new g(100,\"r\",\"QSI_S_ZN_5o5yqpvMVjgDOuN\",\"https://zn5o5yqpvmvjgdoun-wiley.siteintercept.qualtrics.com/SIE/?Q_ZID=ZN_5o5yqpvMVjgDOuN\")).start()}catch(i){}})();\r\n</script><div id='ZN_5o5yqpvMVjgDOuN'></div>\r\n","enabled":false},{"pages":["all"],"location":"header","script":"\r\n<script>\r\n (function(h,o,t,j,a,r){\r\n h.hj=h.hj||function(){(h.hj.q=h.hj.q||[]).push(arguments)};\r\n h._hjSettings={hjid:257151,hjsv:6};\r\n a=o.getElementsByTagName('head')[0];\r\n r=o.createElement('script');r.async=1;\r\n r.src=t+h._hjSettings.hjid+j+h._hjSettings.hjsv;\r\n a.appendChild(r);\r\n })(window,document,'https://static.hotjar.com/c/hotjar-','.js?sv=');\r\n</script>","enabled":false},{"pages":["article"],"location":"header","script":" <script src=\"//get.s-onetag.com/bffe21a1-6bb8-4928-9449-7beadb468dae/tag.min.js\" async defer></script>","enabled":true},{"pages":["homepage"],"location":"header","script":"<meta name=\"facebook-domain-verification\" content=\"irk8y0irxf718trg3uwwuexg6xpva0\" />","enabled":true},{"pages":["homepage","article","category","search"],"location":"footer","script":"\r\n<noscript>\r\n<img height=\"1\" width=\"1\" src=\"https://www.facebook.com/tr?id=256338321977984&ev=PageView&noscript=1\"/>\r\n</noscript>\r\n","enabled":true}]}},"pageScriptsLoadedStatus":"success"},"navigationState":{"navigationCollections":[{"collectionId":287568,"title":"BYOB (Be Your Own Boss)","hasSubCategories":false,"url":"/collection/for-the-entry-level-entrepreneur-287568"},{"collectionId":293237,"title":"Be a Rad Dad","hasSubCategories":false,"url":"/collection/be-the-best-dad-293237"},{"collectionId":295890,"title":"Career Shifting","hasSubCategories":false,"url":"/collection/career-shifting-295890"},{"collectionId":294090,"title":"Contemplating the Cosmos","hasSubCategories":false,"url":"/collection/theres-something-about-space-294090"},{"collectionId":287563,"title":"For Those Seeking Peace of Mind","hasSubCategories":false,"url":"/collection/for-those-seeking-peace-of-mind-287563"},{"collectionId":287570,"title":"For the Aspiring Aficionado","hasSubCategories":false,"url":"/collection/for-the-bougielicious-287570"},{"collectionId":291903,"title":"For the Budding Cannabis Enthusiast","hasSubCategories":false,"url":"/collection/for-the-budding-cannabis-enthusiast-291903"},{"collectionId":299891,"title":"For the College Bound","hasSubCategories":false,"url":"/collection/for-the-college-bound-299891"},{"collectionId":291934,"title":"For the Exam-Season Crammer","hasSubCategories":false,"url":"/collection/for-the-exam-season-crammer-291934"},{"collectionId":301547,"title":"For the Game Day Prepper","hasSubCategories":false,"url":"/collection/big-game-day-prep-made-easy-301547"}],"navigationCollectionsLoadedStatus":"success","navigationCategories":{"books":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/books/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/books/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/books/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/books/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/books/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/books/level-0-category-0"}},"articles":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/articles/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/articles/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/articles/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/articles/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/articles/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/articles/level-0-category-0"}}},"navigationCategoriesLoadedStatus":"success"},"searchState":{"searchList":[],"searchStatus":"initial","relatedArticlesList":[],"relatedArticlesStatus":"initial"},"routeState":{"name":"Article4","path":"/article/technology/software/microsoft-products/excel/shortcut-keys-for-working-in-the-visual-basic-editor-code-window-255374/","hash":"","query":{},"params":{"category1":"technology","category2":"software","category3":"microsoft-products","category4":"excel","article":"shortcut-keys-for-working-in-the-visual-basic-editor-code-window-255374"},"fullPath":"/article/technology/software/microsoft-products/excel/shortcut-keys-for-working-in-the-visual-basic-editor-code-window-255374/","meta":{"routeType":"article","breadcrumbInfo":{"suffix":"Articles","baseRoute":"/category/articles"},"prerenderWithAsyncData":true},"from":{"name":null,"path":"/","hash":"","query":{},"params":{},"fullPath":"/","meta":{}}},"dropsState":{"submitEmailResponse":false,"status":"initial"},"profileState":{"auth":{},"userOptions":{},"status":"success"}}

Shortcut Keys for Working in the Visual Basic Editor Code Window

By: John Walkenbach and

Updated: 09-11-2018

From The Book: Excel VBA Programming For Dummies

Excel VBA Programming For Dummies

Book image

Explore Book Buy On Amazon

At some point, you may find yourself working with many macros at one time. It can be tedious trying to navigate between and within macro procedures by clicking around with the mouse. These keyboard shortcuts allow you to quickly jump to a target procedure, navigate modules, and even find the starting point for variables.

What to Press	What It Does
Ctrl+down arrow	Selects the next procedure.
Ctrl+up arrow	Selects the previous procedure.
Ctrl+Page Down	Shifts one screen down.
Ctrl+Page Up	Shifts one screen up.
Shift+F2	Goes to the selected function or variable.
Ctrl+Shift+F2	Goes to the last position.
Ctrl+Home	Goes to the beginning of module.
Ctrl+End	Goes to the end of module.
Ctrl+right arrow	Moves one word to the right.
Ctrl+left arrow	Moves one word to the left.
End	Moves to the end of the line.
Home	Moves to the beginning of the line.
Tab	Indents the current line.
Shift+Tab	Removes the indent for the current line.
Ctrl+J	Lists the properties and methods for the selected object.

About This Article

This article is from the book:

Excel VBA Programming For Dummies ,

About the book author:

Dick Kusleika has been helping users get the most out of Microsoft Office products for more than 25 years through online forums, blogging, books, and conferences.

This article can be found in the category:

Excel ,