This session is aimed at the person who is new to programming and to Visual Basic. The new user will be led step by step through the various topics listed below and the final part of the session will comprise a case study designed to incorporate all of the features into a working module.
This session is aimed at the person who is new to programming and to Visual Basic. The new user will be led step by step through the various topics listed below and the final part of the session will comprise a case study designed to incorporate all of the features into a working module.
For the existing Visual Basic user, we can tailor a session.
Topics:
Day 1
Overview of Macros In Excel
Recording – Absolute / Relative
Using Macro Buttons and Shortcuts
Relative / Absolute Select
Behind the Scenes
Navigating the Project Explorer
Modifying Macro Code
VB Concepts
Declaring Variables & Constants
Scope
Object Models
Objects and Collections
Methods and Properties
VB Techniques
Conditional Statements
Loops
Functions
Day 2
Buttons
Button Wizard
Understanding Code
Events
Building Properties
Using Object Model
Communicating with the User
Manipulating Properties
Message Boxes
Modal Forms
Communicating with Other Software
Introduction to API’s
Automating Outlook
References
Early / Late Binding
Debugging
Using Breakpoints
Stepping Through Code
At Insight, we are passionate about our clients, in the provision of Microsoft Office training courses and our database design services.
Equally providing you with the correct business solution, the answers to any issues you may have, and to ensure have the correct skills and knowledge in order that they can use their software applications to the full potential.
The Beginning
Insight was launched in January 1986 in Glasgow by two ex-staff members of The Byte Shop, one of the first commercial IT Training organisations in the UK. Even in those early days, we crisscrossed the UK servicing clients such as the North of Scotland Hydro Board, Britoil, North Wales Water Authority, British Alcan, First Group and many others.
36 Years Later
With some of the original staff still running the company, we provide a first class service of standard and tailored training sessions at all levels.We pride ourselves on not just being able to teach our students how to use the software, but how to apply it to a specific job.
Our trainers are more than trainers – they each have a wide range of practical experience and expertise in their area, for example, if you go on one of our database courses, your trainer will have the background of designing, writing and implementing systems over a long period of time and over a wide range of system types.
Attending an AutoCAD course you will find your trainer has a long number of years using the software in many practical situations.
© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy