{"appState":{"pageLoadApiCallsStatus":true},"bookState":{"book":{"headers":{"timestamp":"2025-02-03T08:11:13+00:00"},"bookId":292397,"data":{"name":"VBA For Dummies","title":"VBA For Dummies","slug":"vba-for-dummies","breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Programming & Web Design","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33592"},"slug":"programming-web-design","categoryId":33592},{"name":"General Programming & Web Design","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33610"},"slug":"general-programming-web-design","categoryId":33610}],"description":"<b>VBA helps you put your computer in its place</b> <p><b>Write programs that automate tasks and make Office 2007 work better for you</b></p> <p>If your computer is becoming your boss instead of your servant, start using VBA to tell it what to do! Here's the latest on the VBA IDE and program containers, debugging and controlling your programs, working with multiple applications using a single program, and the most exciting stuff -- programming for all the Office 2007 applications.</p> <p><b>Discover how to</b></p> <ul> <li>Customize an application's interface</li> <li>Quick-launch a VBA program</li> <li>Store and modify information</li> <li>Use VBA with the Ribbon</li> <li>Understand object-oriented programming</li> <li>Avoid runtime errors</li> </ul>","bookOutOfPrint":false,"testBankPinActivationLink":"","publishedDate":"2007-01-10T12:11:06+00:00","primaryISBN":"9780470046500","secondaryISBNs":"9780470126998","learningType":"Advance","primaryCategory":{"categoryId":33610,"title":"General Programming & Web Design","slug":"general-programming-web-design","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33610"}},"secondaryCategory":{"categoryId":33652,"title":"General Microsoft","slug":"general-microsoft","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33652"}},"amazon":{"default":"https://www.amazon.com/gp/product/0470046503/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/0470046503/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/0470046503-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/0470046503/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/0470046503/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/covers/9780470046500.jpg","width":250,"height":350},"authors":[{"authorId":9109,"name":"John Paul Mueller","slug":"john-paul-mueller","description":" <p><b>John Mueller</b> has produced hundreds of books and articles on topics ranging from networking to home security and from database management to heads-down programming. If he had a nickel for every time he is asked the question, “Is the terminator real?” (No!), he could have retired years ago.</p> <p><b>Luca Massaron</b> is a data scientist who specializes in organizing and interpreting big data and turning it into smart data. He has over 20 years??? experience delivering data solutions to clients in a variety of industries. ","hasArticle":true,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9109"}}],"relatedArticles":{"_links":{"self":"https://dummies-api.dummies.com/v2/articles?book=292397&offset=0&size=5"}},"relatedBooks":[{"bookId":292398,"name":"Access 2007 VBA Programming For Dummies","slug":"access-2007-vba-programming-for-dummies","primaryCategory":{"categoryId":33643,"title":"Access","slug":"access","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33643"}},"categoryList":["technology","software","microsoft-products","access"],"image":{"src":"https://www.dummies.com/covers/9780470046531.jpg","width":250,"height":350},"_links":{"self":"https://dummies-api.dummies.com/v2/books/292398"}},{"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":292470,"name":"Access VBA Programming For Dummies","slug":"access-vba-programming-for-dummies","primaryCategory":{"categoryId":33643,"title":"Access","slug":"access","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33643"}},"categoryList":["technology","software","microsoft-products","access"],"image":{"src":"https://www.dummies.com/covers/9780764574115.jpg","width":250,"height":350},"_links":{"self":"https://dummies-api.dummies.com/v2/books/292470"}}],"cheatSheet":null,"bookAuthorBio":"<b data-author-id=\"9109\">John Mueller</b> is a freelance author and technical editor. He has writing in his blood, having produced 71 books and over 300 articles to date. The topics range from networking to artificial intelligence and from database management to heads-down programming. Some of his current books include a Windows power optimization book, a book on .NET security, and books on Amazon Web Services, Google Web Services, and eBay Web Services. His technical editing skills have helped more than 50 authors refine the content of their manuscripts. John has provided technical editing services to both <i>Data Based Advisor</i> and <i>Coast Compute</i> magazines. He has also contributed articles to magazines like <i>DevSource</i>, <i>InformIT</i>, <i>Informant</i>, <i>DevX</i>, <i>SQL Server Professional</i>, <i>Visual C++ Developer</i>, <i>Hardcore Visual Basic</i>, <i>asp.netPRO</i>, <i>Software Test & Performance</i>, and <i>Visual Basic Developer.</i>","additionalResourceLink":"","bookCompanionPage":{"pageId":0,"name":null,"slug":null,"_links":null},"seo":{"metaDescription":"VBA For Dummies (0470046503) teaches you how to customize an application's interface, modify information, and much more.","noIndex":0,"noFollow":0}},"_links":{"self":"https://dummies-api.dummies.com/v2/books/292397"}},"bookLoadedStatus":"success","bookExtras":{},"bookExtrasLoadedStatus":"initial"},"adsState":{"pageScripts":{"headers":{"timestamp":"2025-02-03T05: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":"Book3","path":"/book/technology/programming-web-design/general-programming-web-design/vba-for-dummies-292397/","hash":"","query":{},"params":{"category1":"technology","category2":"programming-web-design","category3":"general-programming-web-design","book":"vba-for-dummies-292397"},"fullPath":"/book/technology/programming-web-design/general-programming-web-design/vba-for-dummies-292397/","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"}}

VBA For Dummies book cover

VBA For Dummies

Author:

John Paul Mueller

Overview

VBA helps you put your computer in its place

Write programs that automate tasks and make Office 2007 work better for you

If your computer is becoming your boss instead of your servant, start using VBA to tell it what to do! Here's the latest on the VBA IDE and program containers, debugging and controlling your programs, working with multiple applications using a single program, and the most exciting stuff -- programming for all the Office 2007 applications.

Discover how to

Customize an application's interface
Quick-launch a VBA program
Store and modify information
Use VBA with the Ribbon
Understand object-oriented programming
Avoid runtime errors

VBA helps you put your computer in its place

Write programs that automate tasks and make Office 2007 work better for you

If your computer is becoming your boss instead of your servant, start using VBA to tell it what to do! Here's the latest on the VBA IDE and program containers, debugging and controlling your programs, working with multiple applications

using a single program, and the most exciting stuff -- programming for all the Office 2007 applications.

Discover how to

Customize an application's interface
Quick-launch a VBA program
Store and modify information
Use VBA with the Ribbon
Understand object-oriented programming
Avoid runtime errors

About The Author

John Mueller is a freelance author and technical editor. He has writing in his blood, having produced 71 books and over 300 articles to date. The topics range from networking to artificial intelligence and from database management to heads-down programming. Some of his current books include a Windows power optimization book, a book on .NET security, and books on Amazon Web Services, Google Web Services, and eBay Web Services. His technical editing skills have helped more than 50 authors refine the content of their manuscripts. John has provided technical editing services to both Data Based Advisor and Coast Compute magazines. He has also contributed articles to magazines like DevSource, InformIT, Informant, DevX, SQL Server Professional, Visual C++ Developer, Hardcore Visual Basic, asp.netPRO, Software Test & Performance, and Visual Basic Developer.