Video training,video training rapidshare.com,video training rapidshare,Video training megaupload,Video training mediafire,free ebook rapidshare,computers books rapidshare,Books rapidshare,Book rapidshare, Book mediafire, video tutorials
Friday, November 28, 2008
Microsoft Visual Basic for Excel Turorials - VTC
Title: Microsoft Visual Basic for Excel
Author: Pravah Pugh
SKU: 33286
ISBN: 1930519567
Release Date: 2001-12-17
Duration: 8 hrs / 104 lessons
Compatibility: Win Vista, XP, 2000, 98SE, Mac OS X, OS 9, Linux
Work Files: No
In Visual Training Company's tutorial Microsoft Visual Basic for Excel, Pravah Pugh helps you get started by going over macros, the VBA programming language, and the VBA development environment. He then teaches you about the use and creation of functions for Visual Basic for Excel and how to access and save code. You will also learn about cell referencing, labels, names and much more. To get started, simply click one of the topics below.
01 Introduction
0101 Course Overview
0102 Macros and VBA - A Demonstration
0103 Using Excel Online Help
0104 Using Visual Basic Online Help
0105 Locating Information Across Help Files
02 Macros - the Quick Solution
0201 Overview
0202 Macro Virus Protection
0203 Recording a Macro
0204 Running a Macro
0205 Reviewing and Organizing Recorded Code
0206 Changing a Macros Functionality
0207 Controlling Access to Macros
0208 Simplifying Access to Macros
0209 Summary
03 The VBA Programming Language
0301 Overview
0302 Objects and Collections
0303 Methods; Properties and Events
0304 Procedures and Functions
0305 Executable Statements
0306 Assignment Statements
0307 Declaration Statements
0308 Variables and Constants
0309 Scope
0310 Lifetime and Data Type
0311 Summary
04 The VBA Development Environment
0401 Overview
0402 Windows
0403 Command Bars
0404 The Code Window
0405 Margin Indicator Bar
0406 Code Interpretation
0407 Type and Status Formatting
0408 Entering Keywords
0409 Syntax Assistance
0410 The Project Explorer
0411 The Properties Window
0412 The Object Browser
0413 Using the Object Browser
0414 Summary
05 Development and Troubleshooting
0501 Overview
0502 Running Code and Debug Printing
0503 'Step Into', Break Mode and the Call Stack
0504 'Step Over', 'Step Out' and 'Run to Cursor'
0505 Breakpoints
0506 Variable Values and the Data Tips Window
0507 The Quick Watch Dialog Box and Watch Window
0508 The Locals Window
0509 Tracking Object Variables
0510 Application Modes
0511 Exploring Application Modes
0512 Design Mode & Running Mode Demonstrations
0513 Run Time Editing and Compiling
0514 Summary
06 Using Functions
0601 Overview
0602 Using User Defined Functions
0603 Changing Function Categories
0604 Creating New Function Categories
0605 Formulae and the Worksheet Function Object
0606 VBA and Excel Function Differences
0607 Summary
07 Code Production and Management
0701 Overview
0702 Automated Placement of Statements
0703 Accessing Code
0704 Using Project References
0705 Saving Code
0706 Password Protection
0707 Summary
08 Cell Referencing
0801 Overview
0802 The Range Property and Selecting Cells
0803 Specifying Multiple Cell Ranges
0804 Qualifying Ranges Returned and Offsets
0805 Other Range Returning Properties
0806 Labels and Names
0807 Ranges in Other Workbooks
0808 Shorthand Notation and 3-D Ranges
0809 Summary
09 Control Structures
0901 Overview
0902 With Control Structure
0903 IF...Then...Else Control Structure
0904 Select Case Control Structure
0905 For...Next Loops
0906 For Each... Next Loops
0907 Do While...Loop and Do Until...Loop
0908 Do...Loop While and Do...Loop Until
0909 Summary
10 Interacting With Users
1001 Overview
1002 The Message Box
1003 The Message Box Constants
1004 The Input Box
1005 Object Positioning
1006 Quiz Example
1007 Protecting Users
1008 Summary
http://rapidshare.com/files/36013772/VETECEEXELVEBEA.part4.rar
http://rapidshare.com/files/36019881/VETECEEXELVEBEA.part1.rar
http://rapidshare.com/files/36025855/VETECEEXELVEBEA.part2.rar
http://rapidshare.com/files/36030547/VETECEEXELVEBEA.part3.rar
Subscribe to:
Post Comments (Atom)
This site does not store any files on its server.We only index and link to content provided by other sites. In case of any query/objection regarding copyright or piracy, please inform us at youzhny197@gmail.com, we will immediately respond to you.
No comments:
Post a Comment