North East King County Regional Public Safety Communication Agency ...

Excel Vbaclass

Description

• exposé
• revision

Page 1 of 7 North East King County Regional Public Safety Communication Agency (NORCOM) GIS Data Development Request for Qualifications Questions and Answers February 26, 2010 The following questions were submitted to NORCOM in response to the GIS Data Development Request for Qualifications and are being answered here by NORCOM. This document supplements information in NORCOM's January 29, 2010 GIS Data Development Request for Qualifications and on February 26, 2010 will be posted at NORCOM's web-site www.

• application software
• details on the esri database
• data development request
• norcom
• current operating system
• corrections management
• fire
• database
• system

Sujets

• Exposé
• Révision
• Proposal
• Microsoft
• System
• Details
• Development
• Software

Informations

• Publié par: ossu
• Nombre de lectures: 31
• Langue: English

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