{"appState":{"pageLoadApiCallsStatus":true},"bookState":{"book":{"headers":{"timestamp":"2024-11-22T12:11:41+00:00"},"bookId":281715,"data":{"name":"Excel VBA Programming For Dummies","title":"Excel VBA Programming For Dummies","slug":"excel-vba-programming-for-dummies","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}],"description":"<b>Find out what Excel is capable of with this step-by-step guide to VBA</b> <p>Short of changing the tires on your car, Microsoft Excel can do pretty much anything. And the possibilities are even more endless when you learn to program with Excel Visual Basic for Applications (VBA). Regardless of your familiarity with Excel VBA, <i>Excel VBA Programming For Dummies</i> can enhance your experience with the popular spreadsheet software. <p>Pretty soon, you'll be doing things you didn't think were possible in Excel, from automating processes to writing your own worksheet functions. You'll learn how to: <ul> <li>Understand the basic tools and operations of Visual Basic for Applications</li> <li>Create custom spreadsheet functions that make life easier for you and the people maintaining your spreadsheets</li> <li>Deal with errors and exceptions and eliminate the bugs in your code</li> </ul> <p>Perfect for anyone who's never even heard of <i>Excel VBA, Excel VBA Programming For Dummies</i> is also a fantastic resource for intermediate and advanced Excel users looking for a heads-up on the latest features and newest functionality of this simple yet powerful scripting language.","bookOutOfPrint":true,"testBankPinActivationLink":"","publishedDate":"2022-02-02T12:11:12+00:00","primaryISBN":"9781119843078","secondaryISBNs":"9781119843085,9781119843092","learningType":"Advance","primaryCategory":{"categoryId":33644,"title":"Excel","slug":"excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"}},"secondaryCategory":{"categoryId":0,"title":null,"slug":null,"_links":null},"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/covers/9781119843078.jpg","width":250,"height":350},"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":true,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/34673"}}],"relatedArticles":{"_links":{"self":"https://dummies-api.dummies.com/v2/articles?book=281715&offset=0&size=5"}},"relatedBooks":[{"bookId":281700,"name":"Excel 2007 VBA Programming For Dummies","slug":"excel-2007-vba-programming-for-dummies","primaryCategory":{"categoryId":33644,"title":"Excel","slug":"excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"}},"categoryList":["technology","software","microsoft-products","excel"],"image":{"src":"https://www.dummies.com/covers/9780470046746.jpg","width":250,"height":350},"_links":{"self":"https://dummies-api.dummies.com/v2/books/281700"}},{"bookId":281701,"name":"Excel 2010 All-in-One For Dummies","slug":"excel-2010-all-in-one-for-dummies","primaryCategory":{"categoryId":33644,"title":"Excel","slug":"excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"}},"categoryList":["technology","software","microsoft-products","excel"],"image":{"src":"https://www.dummies.com/covers/9780470489598.jpg","width":250,"height":350},"_links":{"self":"https://dummies-api.dummies.com/v2/books/281701"}},{"bookId":281704,"name":"Excel 2013 All-in-One For Dummies","slug":"excel-2013-all-in-one-for-dummies","primaryCategory":{"categoryId":33644,"title":"Excel","slug":"excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"}},"categoryList":["technology","software","microsoft-products","excel"],"image":{"src":"https://www.dummies.com/covers/9781118510100.jpg","width":250,"height":350},"_links":{"self":"https://dummies-api.dummies.com/v2/books/281704"}}],"cheatSheet":{"articleId":207995,"slug":"excel-vba-programming-for-dummies-cheat-sheet","title":"Excel VBA Programming For Dummies Cheat Sheet","description":"You can get things done faster and be more productive if you know the keyboard shortcuts for your work environment. This cheat sheet provides a list of useful keyboard shortcuts for Excel VBA programmers. If you're new to VBA, try learning just a few of them at a time until they're part of your work habits.","categoryList":["technology","software","microsoft-products","excel"]},"bookAuthorBio":"<p> <b data-author-id=\"34673\">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>","additionalResourceLink":"","bookCompanionPage":{"pageId":0,"name":null,"slug":null,"_links":null},"seo":{"metaDescription":"Learn how to program with Excel Visual Basic for Applications (VBA) to enhance your experience with the popular spreadsheet software.","noIndex":0,"noFollow":0}},"_links":{"self":"https://dummies-api.dummies.com/v2/books/281715"}},"bookLoadedStatus":"success","bookExtras":{},"bookExtrasLoadedStatus":"initial"},"adsState":{"pageScripts":{"headers":{"timestamp":"2024-11-22T05: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":"Book4","path":"/book/technology/software/microsoft-products/excel/excel-vba-programming-for-dummies-281715/","hash":"","query":{},"params":{"category1":"technology","category2":"software","category3":"microsoft-products","category4":"excel","book":"excel-vba-programming-for-dummies-281715"},"fullPath":"/book/technology/software/microsoft-products/excel/excel-vba-programming-for-dummies-281715/","meta":{"routeType":"book","breadcrumbInfo":{"suffix":"Books","baseRoute":"/category/books"},"prerenderWithAsyncData":true},"from":{"name":null,"path":"/","hash":"","query":{},"params":{},"fullPath":"/","meta":{}}},"profileState":{"auth":{},"userOptions":{},"status":"success"}}

Excel VBA Programming For Dummies book cover

Excel VBA Programming For Dummies

Author:

Overview

Find out what Excel is capable of with this step-by-step guide to VBA

Short of changing the tires on your car, Microsoft Excel can do pretty much anything. And the possibilities are even more endless when you learn to program with Excel Visual Basic for Applications (VBA). Regardless of your familiarity with Excel VBA, Excel VBA Programming For Dummies can enhance your experience with the popular spreadsheet software.

Pretty soon, you'll be doing things you didn't think were possible in Excel, from automating processes to writing your own worksheet functions. You'll learn how to:

Understand the basic tools and operations of Visual Basic for Applications
Create custom spreadsheet functions that make life easier for you and the people maintaining your spreadsheets
Deal with errors and exceptions and eliminate the bugs in your code

Perfect for anyone who's never even heard of Excel VBA, Excel VBA Programming For Dummies is also a fantastic resource for intermediate and advanced Excel users looking for a heads-up on the latest features and newest functionality of this simple yet powerful scripting language.

Find out what Excel is capable of with this step-by-step guide to VBA

Short of changing the tires on your car, Microsoft Excel can do pretty much anything. And the possibilities are even more endless when you learn to program with Excel Visual Basic for Applications (VBA). Regardless of your familiarity with Excel VBA, Excel VBA Programming For Dummies can enhance your experience with the popular spreadsheet software.

Pretty soon, you'll be doing things you didn't think were possible in Excel, from automating processes to writing your own worksheet functions. You'll learn

how to:

Understand the basic tools and operations of Visual Basic for Applications
Create custom spreadsheet functions that make life easier for you and the people maintaining your spreadsheets
Deal with errors and exceptions and eliminate the bugs in your code

Perfect for anyone who's never even heard of Excel VBA, Excel VBA Programming For Dummies is also a fantastic resource for intermediate and advanced Excel users looking for a heads-up on the latest features and newest functionality of this simple yet powerful scripting language.

Excel VBA Programming For Dummies Cheat Sheet

You can get things done faster and be more productive if you know the keyboard shortcuts for your work environment. This cheat sheet provides a list of useful keyboard shortcuts for Excel VBA programmers. If you're new to VBA, try learning just a few of them at a time until they're part of your work habits.

About The 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.