New and Sealed!
LOWEST PRICES ON AMAZON: USED $54, NEW $66
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
LOWEST PRICES ON AMAZON: USED $54, NEW $66
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
- UPC 9781932802337
- ISBN 9781932802337
- Brand Mr Excel
- Mfg Part # Excel 2007 VBA
Payment Methods
Shipping
USPS, $3.99
Payment Policy
We accept Paypal, Money Order (from USPS ONLY!) and Credit cards accepted through Paypal only!
Shipping Policy
SHIPPING WITHIN THE U.S. ONLY!
Return/Exchange Policy
Returns only accepted within 7 days of receipt of item provided you contact us first. Buyer pays for all return shipping.
Please Login or Register first before asking a question.
