资源描述：
《信息时代的管理信息系统8e全套配套课件XLMM.ppt》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、ExtendedLearningModuleM ProgramminginExcelwithVBACopyright©2010bytheMcGraw-HillCompanies,Inc.Allrightsreserved.McGraw-Hill/IrwinSTUDENTLEARNINGOUTCOMESExplainthevalueofusingVBAwithExcel.Defineamacro.Buildasimplemacrousingasubprocedureandafunctionprocedure.ModM-2STUDENTLEARNINGOUTC
2、OMESDescribeanobject.Explainthedifferencebetweenacomment,avariable,andaconstant.ListthevariousVisualBasicapplicationdatatypesandoperators.Describeandbuildamacrothatusestheif-then-else,for-next,do-until,do-while,andselectcasestructures.ModM-3MODULEORGANIZATIONWhyVBA?LearningOutcome
3、#1,#2,#3,TheVisualBasicEditorVBABuildingBlocksElementsofVBAProgrammingLearningOutcome#5Decisions,Decisions,DecisionsLearningOutcome#7WrapItUpModM-4INTRODUCTIONVBA,whichstandsforVisualBasicforApplications,isaprogramminglanguagedevelopedbyMicrosoftExcel,alongwiththeothermember
4、sofMicrosoftOffice,includestheVBAlanguageModM-5INTRODUCTIONExcelVBAisaprogrammingapplicationthatallowsVisualBasiccodetocustomizeyourExcelapplicationsUnitsofVBAcodeareoftenreferredtoasmacrosModM-6INTRODUCTIONOneadvantageofExcelVBAisthemacrorecorderThemacrorecorderisasoftwaretooltha
5、twillletyourecordasequenceofcommandsinExcelandsavethemasamacroModM-7WHYVBA?VBAisaprogramminglanguage,butitalsoservesasamacrolanguageAmacrolanguageisaprogramminglanguagethatincludesbuilt-incommandsthatmimicthefunctionalityavailablefrommenusanddialogboxeswithinanapplicationAmacroisa
6、setofactionsrecordedorwrittenbyauserModM-8WHYVBA?CreateaVBAmacrotoformatandprintamonth-endsalesreportExecutethemacrowithasinglecommandTriggerExceltoautomaticallyperformmanytime-consumingtasksModM-9WHYVBA?Ifyouareabletoperformanoperationmanually,youcanusethemacrorecordertocaptureth
7、atoperationYoucanuseVBAtocreateyourownworksheetfunctionsModM-10WHYVBA?CommonusesforVBAmacros:InsertingtextAutomatingataskAutomatingrepetitivetasksCreatingacustomcommandModM-11WHYVBA?CommonusesforVBAmacros:CreatingacustomtoolbarbuttonCreatingacustommenucommandCreatingasimplifiedfro
8、ntendDevelopingnewworksheetfuncti
