【Lynda】Up and Running with VBA in Excel【CHN】中英文字幕[SRT]
==========教程信息=====================================================
教程名称：Up and Running with VBA in Excel
作者：Curt Frye
主题：Business, Productivity, Developer
使用软件：Excel 2003, 2007, 2010, Visual Basic for Applications
难度等级：高级
时长： 3h 0m
发布日期： Jun 23, 2010
┏ACELY STUDIO，2012
┃更多资源请访问
┃◆唯一发布站：ACELY.CN
┗◆我的博客：http://blog.sina.com.cn/u/1991840741
==========教程目录文件列表=============================================
Up and Running with VBA in Excel[SRT]
├─◆0. Introduction
│ └─◇ 0001 Welcome.srt
│ └─◇ 0002 Using the exercise files.srt
├─◆1. Introducing Visual Basic for Applications (VBA)
│ └─◇ 0101 Introducing object-oriented programming.srt
│ └─◇ 0102 Examining the Excel object model.srt
│ └─◇ 0103 Working in the Visual Basic editor.srt
│ └─◇ 0104 Setting VBA project properties.srt
│ └─◇ 0105 Creating, exporting, and deleting code modules.srt
│ └─◇ 0106 Creating a subroutine or function.srt
│ └─◇ 0107 Controlling procedure scope and visibility.srt
│ └─◇ 0108 Adding comments to the code.srt
│ └─◇ 0109 Running a VBA routine.srt
│ └─◇ 0110 Adding code to a recorded macro.srt
├─◆2. Defining Variables, Constants, and Calculations
│ └─◇ 0201 Introducing Excel VBA data types.srt
│ └─◇ 0202 Declaring variables and requiring declaration before use.srt
│ └─◇ 0203 Managing variable scope.srt
│ └─◇ 0204 Defining static variables and constants.srt
│ └─◇ 0205 Creating a calculation using mathematical operators.srt
│ └─◇ 0206 Defining arrays.srt
│ └─◇ 0207 Defining and using object variables.srt
│ └─◇ 0208 Streamlining code references using With…End With statements.srt
├─◆3. Adding Logic to Your VBA Code
│ └─◇ 0301 Repeating a task using a For…Next loop.srt
│ └─◇ 0302 Stepping through all items of a collection using a For…Each loop.srt
│ └─◇ 0303 Repeating a task with a Do loop.srt
│ └─◇ 0304 Performing a task when conditions are met using If…Then.srt
│ └─◇ 0305 Selecting which action to take using a Case statement.srt
├─◆4. Debugging Your VBA Code
│ └─◇ 0401 Managing errors using On Error statements.srt
│ └─◇ 0402 Stepping through a subroutine or function.srt
│ └─◇ 0403 Setting breakpoints in the code.srt
│ └─◇ 0404 Verifying output using the Immediate window.srt
│ └─◇ 0405 Watching a value in a routine.srt
├─◆5. Managing Workbook Elements and Data in VBA
│ └─◇ 0501 Writing a value to a cell.srt
│ └─◇ 0502 Cutting, copying, and pasting cell data.srt
│ └─◇ 0503 Finding values in cells.srt
│ └─◇ 0504 Referring to cells using the Offset function.srt
│ └─◇ 0505 Concatenating text strings.srt
│ └─◇ 0506 Returning part of a string.srt
│ └─◇ 0507 Managing worksheets with VBA.srt
│ └─◇ 0508 Managing workbooks with VBA.srt
├─◆6. Adding Advanced Elements to Your Workbook
│ └─◇ 0601 Turning off screen updating within a macro.srt
│ └─◇ 0602 Using worksheet functions in a macro.srt
│ └─◇ 0603 Acquiring values using an input box or message box.srt
│ └─◇ 0604 Calling a subroutine from another subroutine.srt
├─◆7. Using Excel Events in Your VBA Code
│ └─◇ 0701 Running a procedure when you open, close, or save a workbook.srt
│ └─◇ 0702 Running a procedure when a cell range changes.srt
│ └─◇ 0703 Triggering a procedure using a specific key sequence.srt
├─◆8. Putting It All Together
│ └─◇ 0801 Applying techniques in a Capstone project.srt
├─◆Conclusion
│ └─◇ Goodbye.srt
◇
【本字幕由ACELY.CN独家制作发布】
┏
┃本套教程字幕包含中文字幕
┃中文字幕使用机器翻译，对翻译结果中不当内容不承担任何责任！
┃更多中文字幕请访问唯一发布站【ACELY.CN】
┃本站中文字幕未经允许一律严禁转载！
┗
标签：Excel