{"appState":{"pageLoadApiCallsStatus":true},"articleState":{"article":{"headers":{"creationTime":"2016-03-26T07:59:03+00:00","modifiedTime":"2017-02-27T21:24:30+00:00","timestamp":"2022-09-14T18:17:35+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":"Excel Macros: Shortcut Keys for Working in the VBE Code Window","strippedTitle":"excel macros: shortcut keys for working in the vbe code window","slug":"excel-macros-shortcut-keys-for-working-in-the-code-window-in-visual-basic-editor","canonicalUrl":"","seo":{"metaDescription":"What to Press on Your Keyboard What It Does Ctrl + Down Arrow Selects the next procedure Ctrl + Up Arrow Selects the previous procedure Ctrl + Page Down Shifts ","noIndex":0,"noFollow":0},"content":"<table>\r\n<tbody>\r\n<tr>\r\n<td width=\"338\"><strong>What to Press on Your Keyboard</strong></td>\r\n<td width=\"375\"><strong>What It Does</strong></td>\r\n</tr>\r\n<tr>\r\n<td width=\"338\">Ctrl + Down Arrow</td>\r\n<td width=\"375\">Selects the next procedure</td>\r\n</tr>\r\n<tr>\r\n<td width=\"338\">Ctrl + Up Arrow</td>\r\n<td width=\"375\">Selects the previous procedure</td>\r\n</tr>\r\n<tr>\r\n<td width=\"338\">Ctrl + Page Down</td>\r\n<td width=\"375\">Shifts one screen down</td>\r\n</tr>\r\n<tr>\r\n<td width=\"338\">Ctrl + Page Up</td>\r\n<td width=\"375\">Shifts one screen up</td>\r\n</tr>\r\n<tr>\r\n<td width=\"338\">Shift + F2</td>\r\n<td width=\"375\">Goes to the selected function or variable</td>\r\n</tr>\r\n<tr>\r\n<td width=\"338\">Ctrl + Shift + F2</td>\r\n<td width=\"375\">Goes to the last position</td>\r\n</tr>\r\n<tr>\r\n<td width=\"338\">Ctrl + Home</td>\r\n<td width=\"375\">Goes to the beginning of module</td>\r\n</tr>\r\n<tr>\r\n<td width=\"338\">Ctrl + End</td>\r\n<td width=\"375\">Goes to the end of module</td>\r\n</tr>\r\n<tr>\r\n<td width=\"338\">Ctrl + Right Arrow</td>\r\n<td width=\"375\">Moves one word to the right</td>\r\n</tr>\r\n<tr>\r\n<td width=\"338\">Ctrl + Left Arrow</td>\r\n<td width=\"375\">Moves one word to the left</td>\r\n</tr>\r\n<tr>\r\n<td width=\"338\">End</td>\r\n<td width=\"375\">Moves to the end of the line</td>\r\n</tr>\r\n<tr>\r\n<td width=\"338\">Home</td>\r\n<td width=\"375\">Moves to the beginning of the line</td>\r\n</tr>\r\n<tr>\r\n<td width=\"338\">Tab</td>\r\n<td width=\"375\">Indents the current line</td>\r\n</tr>\r\n<tr>\r\n<td width=\"338\">Shift + Tab</td>\r\n<td width=\"375\">Removes the indent for the current line</td>\r\n</tr>\r\n<tr>\r\n<td width=\"338\">Ctrl + J</td>\r\n<td width=\"375\">Lists the properties and methods for the selected object</td>\r\n</tr>\r\n</tbody>\r\n</table>","description":"<table>\r\n<tbody>\r\n<tr>\r\n<td width=\"338\"><strong>What to Press on Your Keyboard</strong></td>\r\n<td width=\"375\"><strong>What It Does</strong></td>\r\n</tr>\r\n<tr>\r\n<td width=\"338\">Ctrl + Down Arrow</td>\r\n<td width=\"375\">Selects the next procedure</td>\r\n</tr>\r\n<tr>\r\n<td width=\"338\">Ctrl + Up Arrow</td>\r\n<td width=\"375\">Selects the previous procedure</td>\r\n</tr>\r\n<tr>\r\n<td width=\"338\">Ctrl + Page Down</td>\r\n<td width=\"375\">Shifts one screen down</td>\r\n</tr>\r\n<tr>\r\n<td width=\"338\">Ctrl + Page Up</td>\r\n<td width=\"375\">Shifts one screen up</td>\r\n</tr>\r\n<tr>\r\n<td width=\"338\">Shift + F2</td>\r\n<td width=\"375\">Goes to the selected function or variable</td>\r\n</tr>\r\n<tr>\r\n<td width=\"338\">Ctrl + Shift + F2</td>\r\n<td width=\"375\">Goes to the last position</td>\r\n</tr>\r\n<tr>\r\n<td width=\"338\">Ctrl + Home</td>\r\n<td width=\"375\">Goes to the beginning of module</td>\r\n</tr>\r\n<tr>\r\n<td width=\"338\">Ctrl + End</td>\r\n<td width=\"375\">Goes to the end of module</td>\r\n</tr>\r\n<tr>\r\n<td width=\"338\">Ctrl + Right Arrow</td>\r\n<td width=\"375\">Moves one word to the right</td>\r\n</tr>\r\n<tr>\r\n<td width=\"338\">Ctrl + Left Arrow</td>\r\n<td width=\"375\">Moves one word to the left</td>\r\n</tr>\r\n<tr>\r\n<td width=\"338\">End</td>\r\n<td width=\"375\">Moves to the end of the line</td>\r\n</tr>\r\n<tr>\r\n<td width=\"338\">Home</td>\r\n<td width=\"375\">Moves to the beginning of the line</td>\r\n</tr>\r\n<tr>\r\n<td width=\"338\">Tab</td>\r\n<td width=\"375\">Indents the current line</td>\r\n</tr>\r\n<tr>\r\n<td width=\"338\">Shift + Tab</td>\r\n<td width=\"375\">Removes the indent for the current line</td>\r\n</tr>\r\n<tr>\r\n<td width=\"338\">Ctrl + J</td>\r\n<td width=\"375\">Lists the properties and methods for the selected object</td>\r\n</tr>\r\n</tbody>\r\n</table>","blurb":"","authors":[{"authorId":8969,"name":"Michael Alexander","slug":"michael-alexander","description":" <p><B>Michael Alexander </b>is a senior consultant at Slalom Consulting with more than 15 years’ experience in data management and reporting. He is the author of more than a dozen books on business analysis using Microsoft Excel, and has been named Microsoft Excel MVP for his contributions to the Excel community. </p> ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/8969"}}],"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":248395,"title":"Manually Editing Data Connections in Excel","slug":"manually-editing-data-connections-excel","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/248395"}},{"articleId":207533,"title":"Excel Macros For Dummies Cheat Sheet","slug":"excel-macros-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/207533"}},{"articleId":144111,"title":"10 Jobs for Excel Macro Gurus","slug":"10-jobs-for-excel-macro-gurus","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/144111"}},{"articleId":144104,"title":"Excel Macros: Standard Visual Basic Editor Shortcut Keys","slug":"excel-macros-standard-visual-basic-editor-shortcut-keys","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/144104"}},{"articleId":144099,"title":"Excel Macros: Shortcut Keys for Navigating the VBE Project Window","slug":"excel-macros-shortcut-keys-for-navigating-the-project-window-in-visual-basic-editor","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/144099"}}],"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":281713,"slug":"excel-macros-for-dummies","isbn":"9781119844433","categoryList":["technology","software","microsoft-products","excel"],"amazon":{"default":"https://www.amazon.com/gp/product/1119844436/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119844436/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/1119844436-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119844436/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119844436/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/9781119844433-203x255.jpg","width":203,"height":255},"title":"Excel Macros 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":["9781119844433"]}]\" id=\"du-slot-63221abf5f6b9\"></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":["9781119844433"]}]\" id=\"du-slot-63221abf5fc56\"></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":144105},"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/excel-macros-shortcut-keys-for-working-in-the-code-window-in-visual-basic-editor-144105/","hash":"","query":{},"params":{"category1":"technology","category2":"software","category3":"microsoft-products","category4":"excel","article":"excel-macros-shortcut-keys-for-working-in-the-code-window-in-visual-basic-editor-144105"},"fullPath":"/article/technology/software/microsoft-products/excel/excel-macros-shortcut-keys-for-working-in-the-code-window-in-visual-basic-editor-144105/","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"}}

Excel Macros: Shortcut Keys for Working in the VBE Code Window

By: Michael Alexander and

Updated: 02-27-2017

From The Book: Excel Macros For Dummies

Excel Macros For Dummies

Explore Book Buy On Amazon

What to Press on Your Keyboard	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 Macros 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 ,

Article Categories

Book Categories

Collections