Excel VBA Training
Excel
Excel VBA Training - Chicago
To find out more about this class please visit our website at http://www.trainingconnection.com or call 312.698.4475
Excel 2003 VBA
What you will learn
1. Excel 2003 VBA - $395 (1 day - instructor-led)
To find out more about this class please visit our website at http://www.trainingconnection.com or call 312.698.4475
Excel 2003 VBA
This course is designed to give experienced Excel users proficiency in creating procedures that run in response to specific events, creating user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.
What you will learn
- To work with Object Properties and Methods
- Attach code to events and buttons
- Using Variables, Procedures and Functions in VBA
- Control Structures to execute code
- Add User Forms and Controls
- Validate User entries
- Error handling and debugging
- Visual Basic Termimology
- Start the Visual Basic Editor
- Work with Object properties and methods
- Attach code to events and buttons
- Use Object Browser to get information about Objects
- Use Variables of various Data Types
- Manipulate Data using Expressions
- Declare and use Variables of correct Scope
- Declare and use Procedures of correct Scope
- Create Sub and Function Procedures
- Call one Procedure from other
- Use Decision Structures to create procedures that execute code
- Use Loop structures to execute code repeatedly
- Add a User Form to your project
- Add Controls to User Form
- Attach Handle Events to Controls
- Validate Data entered
- Identify compile-time, run-time and logical errors
- Use the Debugging Tools
- Write Error-handling code to trap errors
|
|
||||||||||
Training
Provided by Training Connection
- asked: What are the dates and locations for this course? Thanks, Kaustubh
- asked: Do you offer these classes on a Saturday? How much does the class cost? Where would this class be held? Thanks Charles
- M asked: Please forward relavant information such as when course will take place and if there is an advance class.
- A asked: When are you holding classes?
- J asked: Requesting more info on Access/Excel VBA Training: At what location is this training? What are the dates for this training? How do I register?
Excel VBA Training
--
About The Training Provider: Training Connection
Training Connection - Training Connection
Training Connection provides training in the world's most popular desktop applications and in business skills.
All our hands on training sessions are delivered by a qualified industry leading professionals. We keep our class sizes small so that each student is well looked after.
www.trainingconnection.com
Computer Courses include Photoshop Training, Dreamweaver...
