Child Rights Oslo

Excel Vbaclass

Description

• cours - matière potentielle : during school hours
• exposé

1 Implementation of CRC in NorthEast

• disapp by gosl forces 26 apr
• trinco by sla
• age youth
• old child
• such youths
• unicef
• sla
• children
• child

Sujets

• Exposé
• Tamils Rehabilitation Organisation
• Ampara
• Vavuniya
• Batticaloa

Informations

• Publié par: phoec
• Nombre de lectures: 16

Extrait

Excel VBA Class

Glenn Harris Microsoft Certified Trainer Office Master Instructor Excel Class NYC

Lesson 0 – Programming Logic

 Fundamentals of Programming

Macros

 Strengths/Weaknesses  How To Record A Macro  How To Edit A Macro  How To Debug A Macro

The VB Editor

 VB Editor Menus  VB Editor Toolbars  VB Editor Panes

Fix Macros

 Declare Variables  Variable Substitution  Variable Concatenation  Get The Name Of The Activesheet

Writing VBA Programs

 Pseudocode  Navigate Cells/Sheets With VBA  Add/Name Sheets With VBA  Find The Last Row  Looping Control Structures  If/Then Control Structures  More Debugging

VBA Formulas, Functions and Dialogs

 MessageBox Intrinsic Function  InputBox Intrinsic Function  Write A Function To A Cell  Perform A Function Call In Memory  Write Your Own Functions  Workbook Events  Range Intersections  Macros That Call Other Macros And Pass Variables

VBA Forms

 Insert A Form  Add Form Controls – Labels – Text Boxes – Drop Down List Boxes – Checkboxes – ActiveX Controls

Object Variables

 Data Tables/Array Formulas  Named Ranges  Object Variables  More Looping Control Structures

Excel Help Resources