Description: New and Sealed! Developed and tested for business training, this CD-ROM is ideally suited for self-instruction using a screen shot approach versus an overabundance of text. More than 1,400 slides, with examples drawn from actual cases, are divided into three modules covering VBA basics, how to calculate with VBA, and letting VBA interact with the user. Module 1:Basic Essentials Object Oriented Recording Macros Branch Statements Interaction Variables (Value Type) Variables (Object Type) Collections Loop Statements Variables as Arguments Pivot Tables and Charts Module 2: Formulas and Arrays Dates and Calendars The Current-Region Property WorksheetFunction Property Formula Property FormulaR1C1 Custom Functions Array Functions 1D- and 2D-Arrays Customized Arrays Variant Arrays Module 3: Buttons, Forms, and More Importing and Exporting Buttons, Bars, Menus Application Events User Forms Data Entry + Mail Merge Custom Objects (Classes) Class Collections Error Handling Dr. Gerard Verschuuren (Mr Excel) is a Microsoft Certified Professional specializing in VB, VBA, and VB.NET. He is the author of Access VBA Made Accessible, Excel for Scientists, Excel for Scientists and Engineers, From VBA to VSTO, Join the Excellers League, Master the Web, Slide Your Way Through Excel VBA, and Your Access to the World. Shipping is available to anyone not local. This item is listed on multiple sites. NNNN
Price: 49.99 USD
Location: Champaign, Illinois
End Time: 2024-08-31T07:00:01.000Z
Shipping Cost: 4.49 USD
Product Images
Item Specifics
Restocking Fee: No
Return shipping will be paid by: Buyer
All returns accepted: Returns Accepted
Item must be returned within: 30 Days
Refund will be given as: Money Back
Number of Pages: 100 Pages
Language: English
Publication Name: Excel 2007 Vba
Publisher: Tickling Keys, Incorporated
Publication Year: 2008
Subject: Desktop Applications / Spreadsheets, Programming Languages / Visual Basic, Enterprise Applications / General
Item Height: 0.4 in
Item Weight: 2.7 Oz
Type: Textbook
Subject Area: Computers
Author: Gerard Verschuuren
Item Length: 5 in
Series: Visual Training Ser.
Item Width: 5 in
Format: CD-ROM