Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Articles & Books From Jan Karel Pieterse
Cheat Sheet / Updated 03-27-2016
You can do a lot with Excel and VBA just by recording macros, but you need to really dig into Excel VBA programming if you want to turn your Excel workbooks and spreadsheets into supercharged solutions.
Article / Updated 03-26-2016
Excel 2007 alone is a powerful tool for data analysis and number-crunching. But when you add VBA programming to your Excel workbooks and spreadsheets, your opportunities for transforming simple data into wonderful information are nearly endless. Use the following functions to create powerful Excel programs in VBA.
Step-by-step instructions for creating VBA macrosHarness the power of VBA and create custom Excel applicationsMake Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus, and much more.