P: 307-686-3025 F: 307-686-7563 info@k2technologies.net   Microsoft Access 2003 Level I   Microsoft Access 2003 Level II   Microsoft Access 2003 Level III   Microsoft Access 2007 Level I   Microsoft Access 2007 Level II   Microsoft Access 2007 Level III   Microsoft Excel 2003 Level I   Microsoft Excel 2003 Level II   Microsoft Excel 2003 Level III   Microsoft Excel 2003 Level IV   Microsoft Excel 2007 Level I   Microsoft Excel 2007 Level II   Microsoft Excel 2007 Level III   Microsoft Excel 2007 Level IV -Power User   Microsoft Excel 2007 Level V - VBA Programming   Microsoft Office 2007 Basics - For Outlook, Excel and Word   Microsoft Outlook 2003 Level I   Microsoft Outlook 2003 Level II   Microsoft Outlook 2007 Level I   Microsoft PowerPoint 2003 Level I   Microsoft PowerPoint 2003 Level II   Microsoft Powerpoint 2007 - Sales Presentations   Microsoft PowerPoint 2007 Level I   Microsoft Powerpoint 2007 Level II   Microsoft Project 2003 Level I   Microsoft Project 2003 Level II   Microsoft Project 2007 Level I   Microsoft Project 2007 Level II   Microsoft Publisher 2003 Level I   Microsoft Publisher 2003 Level II   Microsoft Publisher 2007 Level I   Microsoft SharePoint Designer 2007 Level I   Microsoft Windows 7 - Basic   Microsoft Windows 7 Advanced   Microsoft Windows 7 – New Features   Microsoft Windows XP - Advanced   Microsoft Windows XP - Basic Skills   Microsoft Word 2003 Level I   Microsoft Word 2003 Level II   Microsoft Word 2003 Level III   Microsoft Word 2003 Level IV   Microsoft Word 2007 Level I   Microsoft Word 2007 Level II   Microsoft Word 2007 Level III   PC Security   Photoshop Elements 8.0: Level I   QuickBooks Pro 2010 – For Windows: Advanced   QuickBooks Pro 2010 – For Windows: Introduction   Using Facebook To Enhance Your Business - Introduction Microsoft Excel 2007 Level V - VBA Programming Class Duration: 6 hours Class Cost: $149.00 In this 6 hour class you will use the Visual Basic for Applications (VBA) terminology and start Visual Basic Editor (VBE), save workbooks in a macro-enabled file format, work with object Browser to get information about objects. Use the variables of relevant data types, manipulate data by using expressions, get input from the user, declare and use variables of correct scope, declare and use procedures of correct scope, create Sub and Function procedures, and call one procedure from another. Use decision structures to create procedures that execute code, based on specific conditions, and use loop structures to execute specific code repeatedly. Add a user form to your project and add controls to the user form, handle events attached to controls in a user form, and validate the data entry in the controls. Identify compile-time, run-time, and logical errors in code, use the debugging tools, and write error-handling code to trap errors. You will get the most out of this course if your goal is to become proficient in using Visual Basic for Applications (VBA) to create procedures for controlling the behavior and appearance of an Excel worksheet, create procedures that run in response to specific events, create user forms to accept or display data, validate the data entry in user forms, and debug and handle errors in code.   An upcoming training session for this course has not been scheduled yet. Please contact us for the next available session. Home   |   IT Solutions   |   Telephone / Wiring   |  Web Design Support   |   Contact © Copyright 2008. K2 Technologies. All Rights Reserved.