资源描述:
《Microsoft_Excel_VBA_Programming_for_Dummies_2010.pdf》由会员上传分享,免费在线阅读,更多相关内容在学术论文-天天文库。
1、spine=.8160”Computers/Spreadsheets™2ndEditionAccelerateintotheExcelMakingEverythingEasier!fastlaneandzipthrough2ndEditionExcelspreadsheetcustomizationsMicrosoft®Openthebookandfind:Microsoft®AreyoureadytomakeExceljumpthroughhoops?Do•HowtoworkintheVisualBasic®®yourspre
2、adsheetsworkexactlythewayyouwant?WithEditorVBAProgramming®VBAthisbook,youcansay“yes”!Inside,you’llfindstep-by-step•Tipsforerror-handlingandbugExcelinstructionsonhowtosignificantlyenhancethepowerofexterminationExcelusingtheVBAlanguage.You’llsoonbebuildingyour•Waystobu
3、ildautomaticownExcelapplicationssoyoucangetthemostoutofproceduresandeventsyourdata.•HowtousetheExcelmacroProgramming•DiveintoVBA—seehowVBAisimplementedinExcel,applyrecorderadvancedtechniques,anduseVBAwithotherOfficeapplications•UserFormtechniquesandtricks•Getintoit—e
4、xploreprogrammingconceptsfromrangeobjectsandworksheetfunctionstoeventsanderror-handling•InstructionsfordesigningVBAmacros•Communicationiskey—learnhowtobuilddialogboxesthatlookliketheycamestraightfromMicrosoft’ssoftwarelab•Stepsforaccessingyourmacrosthroughtheuserinte
5、rface•Safetyfirst—useExcelmacrostomakeyourspreadsheetsmoresecureandlockoutviruses•SecretsforcreatingExceladd-ins•Makeityourown—developcustomworksheetfunctions,createadd-ins,designuser-orientedapplications,andboostyourcareeroptionsLearnto:•Usetheessentialtoolsandopera
6、tionsGotoDummies.com®forVBAVisitthecompanionWebsiteathttp://www.dummies.com/forvideos,step-by-stepexamples,go/excelvbaprogrammingfd2e,whereyoucandownloadthehow-toarticles,ortoshop!•Workwithrangeobjectsandcontrolsamplefilesfeaturedinthebookandviewbonuschaptersprogramf
7、low•Handleerrorsandeliminatebugsinyourcode•Developcustomuserinterfacesforyour$29.99US/$35.99CN/£21.99UKapplications,includingdialogboxesISBN978-0-470-50369-0JohnWalkenbachisprincipalofJ-WalkandAssociates,Inc.,aleadingauthorityonspreadsheetsoftwareandcreatoroftheaward
8、-winningPowerUtilityPak.Walkenbachhaswrittenmorethan50booksand300articlesforpublicationsincludingPCWorld,InfoWorld,andWindows.JohnW