You can do these things, and many more, by programming in Visual Basic for Applications (VBA). VBA is a programming language that is actually a part of all the programs in the Microsoft Office suite-including Excel. You can use VBA to create mini-programs that work within the Microsoft Office applications. VBA is based on the concept of Object-Oriented Programming (OOP). OOP is a programming concept in which all the elements of the program are considered as objects.

VBA is more powerful and provides greater flexibility than recording macros, because its code can execute automatically in response to an action such as a decision-based task or an error. Using the VBA Editor within Excel, you can directly create and access objects to control and manipulate the behavior of the application.

The Visual Basic Editor provides tools that help you create procedures and manipulate the properties and methods of an object.

If you are interested in learning more about VBA for Excel, this class is scheduled on Friday, May 16, 2008 and runs from 9-4. We will review macros and work in a "hands-on" environment in the VB Editor throughout the day.  Please contact Cindy Prindle if you have any questions or Sarah Loeffelholz if you would like to register for this class. You can contact us by e-mail at cprindle@habco.com, or sloeffelholz@habco.com, or by phone at (608) 784-7737.  You can also register for any of our in-house and on-line classes on our website at www.habco.com.  Point to The Training Center on the menu bar and click on the Registration option.  We welcome the opportunity to give our clients the competitive edge by helping the employees of your company become more efficient with your software.

Top

The scores in the chart below average all of the class evaluations from
January through December 2007.

It reflects what you thought about us in 2007!

Thank you to all of our students who participated in our classes and provided us with honest feedback!

Top

 Word 2007: The Autotext feature in earlier versions of MS Word is replaced by the Quick Parts tool in Word 2007. This feature allows you to avoid having repeatedly to reenter the same content in different documents. Quick Parts are created using the Insert Ribbon.

PowerPoint 2007: SmartArt is a new creative tool available in PowerPoint 2007 which allows you to insert and edit some advanced illustrated objects. This tool allows you to create dynamic graphics as visual representation of any type of information. It is found in the Insert Ribbon.

 Excel 2007: Excel 2007 size limitations have decreased significantly from earlier versions. Excel 2007 now holds more data than ever before!

• Total Columns = 16,384 (use to be 256)
• Total Rows = 1,048,576 (use to be 65,536)
• Total Sheets = unlimited (use to be 255)

Access 2007: Access 2007 has a new feature that allows you to add a total row to your table in Datasheet View. This new feature not only shows the sums, but it can also display counts, averages, maximums, and minimums.

Top