EXCEL VBA Step by Step Guide To Learning Excel Programming Language For Beginners by Jason Jay
Contents of EXCEL VBA PDF Book
- EXCEL VBA
- Introduction
- CHAPTER VBA Developer TAB
- Accesing to the Developer TAB
- Quiz
- CHAPTER Macros
- Creating a Macro
- Relative References
- Running the Macro
- Saving a Macro-Enabled Workbook
- Quiz
- CHAPTER Starting with VBA
- What if I need to fill the cells up to ?
- Insert Form Button
- Simple things a Macro can’t do
- Insert ActiveX Button
- Variables, Do and Loop
- What is the advantage of declaring variables as byte, integer or any other?
- APPs Performance
- MSGBOX
- If and Select Case
- Quiz
- CHAPTER Project: Creating a Simple Calculator using ActiveX
- What is a Module?
- How to create a Module
- Adding Letters?
- Quiz
- CHAPTER Project: Calculator using Forms
- Review
- FORMS
- Commmand Buttons code
- Excel Formulas on VBA
- Combining VBA and a Spreadsheet
- Starting with Declarations:
- Open and Close declarations: Displaying a form without looking any spreadsheet
- Macro Security
- Comments
- The whole code for Calculator Project
- Command Buttons Order
- Adding Password to VBA Code
- Quiz
- Interacting with other Applications
- Opening other apps from Excel
- Sending an Outlook e-mail from Excel:
- Exercises Solutions