Office Software - Excel Software - Microsoft Software - QuickBooks Software - Visual Software - Comptuer Software - Web Software - Sharepoint Software - Photoshop Software - Mac Software - QuarkXPress Software - management Software - Project Software - Learn Software - email Software - Network Software - Linux Software - Unix Software - Work Software - Net Software - ASP Software - PHP Software - HTML Software - CMS Software - XML Software - Mobile Software -
Online Technology Support Education Word Online Help Graphics Software Help Business Tutorials DVDs Adobe Teaching Support Technology Lessons Advice Business CDs
Microsoft Visual Basic for Excel |
| Product Description : 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. |
Microsoft Visual Basic for ExcelIntroductionCourse OverviewMacros and VBA - A Demonstration Using Excel Online Help Using Visual Basic Online Help Locating Information Across Help Files Macros - the Quick SolutionOverviewMacro Virus Protection Recording a Macro Running a Macro Reviewing and Organizing Recorded Code Changing a Macros Functionality Controlling Access to Macros Simplifying Access to Macros Summary The VBA Programming LanguageOverviewObjects and Collections Methods; Properties and Events Procedures and Functions Executable Statements Assignment Statements Declaration Statements Variables and Constants Scope Lifetime and Data Type Summary The VBA Development EnvironmentOverviewWindows Command Bars The Code Window Margin Indicator Bar Code Interpretation Type and Status Formatting Entering Keywords Syntax Assistance The Project Explorer The PropertiesWindow The Object Browser Using the Object Browser Summary Development and TroubleshootingOverviewRunning Code and Debug Printing Step Into, Break Mode and the Call Stack Step Over, Step Out and Run to Cursor Breakpoints Variable Values and the Data Tips Window The Quick Watch Dialog Box and Watch Window The Locals Window Tracking Object Variables Application Modes Exploring Application Modes Design Mode & Running Mode Demonstrations Run Time Editing and Compiling Summary Using FunctionsOverviewUsing User Defined Functions Changing Function Categories Creating New Function Categories Formulae and the Worksheet Function Object VBA and Excel Function Differences Summary Code Production and ManagementOverviewAutomated Placement of Statements Accessing Code Using Project References Saving Code Password Protection Summary Cell ReferencingOverviewThe Range Property and Selecting Cells Specifying Multiple Cell Ranges Qualifying Ranges Returned and Offsets Other Range Returning Properties Labels and Names Ranges in Other Workbooks Shorthand Notation and 3-D Ranges Summary Control StructuresOverviewWith Control Structure IF...Then...Else Control Structure Select Case Control Structure For...Next Loops For Each... Next Loops Do While...Loop and Do Until...Loop Do...Loop While and Do...Loop Until Summary Interacting With UsersOverviewThe Message Box The Message Box Constants The Input Box Object Positioning Quiz Example Protecting Users Summary |
