Advanced MS Office: with VBA
You don’t have to be a computer programmer to take advantage of the power and flexibility that Visual Basic for Applications (VBA) has to offer.
After this workshop you will gain the skills to take MS Office to a whole new level and uncover its full potential.
Visual Basic for Applications (VBA) is the programming language built into Microsoft Office products and is the basis for macros and functions. Over two days of hands-on activities you will learn to customize your projects by using objects and code in MS Excel, Access, and Word applications to accomplish procedures that go far beyond the scope of recorded macros. Design and use objects, such as form, button, user input box, and list box, as well as decision (If-Then and Select Case) and repetitive (Do loop and For-Next) procedures.
Come and learn techniques and design features that will let you get the most from this powerful software enhancing tools. This two-day workshop is for the MS Office user who needs to customize MS Office applications or for the programmer who seeks an introduction to Visual Basic syntax and object-oriented, event-driven programming. The concepts presented are helpful for individual use or when designing documents and forms intended for use by others.
Prerequisites:
Familiarity with Excel, Access, and Windows is expected. No programming experience is necessary.
Topics Include:
- CreateVBA Objects and code in Microsoft Word, Excel, and Access
- Use Visual BASIC Editor
- Introduction to programming terms and vocabulary
- Define and use variables
- Write coding statements to control processing
- Add/modify properties and methods related to objects
- Objects: Form Command Button, Label, Text Box, Frame, Option Button, Check Box, Image, Combo Box, List Box, Form Field, DoCmd
- Coding Functions: Val, Format, IsNumeric, IsDate, Ucase, InputBox, MsgBox, DateValue, DateAdd, Len
- Events: Click, Load, Unload, GotFocus, LostFocus, Close, Open, Current, Initialize, Timer
|