Description
- Product Features
- You’ll discover how to:
- An introduction to the VBA language
- The essential foundation, including the Visual Basic Editor (VBE) and its components, modules, Excel object model, subroutines and functions and the Excel macro recorder
- The essential VBA language elements, including comments, variables and constants and labels
- Using VBA and worksheet functions, including a list and examples
- Using VBA code to modify the Excel menu system
- Creating worksheet functions and working with various types of arguments
- Help & Support
- FAQs
- Returns Policy
Shows ordinary users how to harness the power of Visual Basic for Applications (VBA) and create custom Excel applications
This book introduces people to a wide array of new Excel options, including creating new worksheet functions, automating tasks and operations, creating new toolbars and menus, designing custom dialog boxes and add-ins, and much more
Begins with the most important tools and operations for the Visual Basic Editor, then provides an overview of the essential elements and concepts for programming with Excel
Excel VBA Programming for Dummies