Excel VBA - Step by Step Guide To Learning Excel Programming Language For Beginners

EXCEL VBA 2 Step-By-Step Guide To Learning Excel Programming Language For Beginners 2 Jason Jay 2 Introduction 6 CHAPTER 1 8 Accesing to the Developer TAB 8 Quiz 1 9 CHAPTER 2 10 Creating a Macro 10 Relative References 12 Running the Macro 12 Saving a Macro-Enabled Workbook 13 Quiz 2 14 CHAPTER 3 17 What if I need to fill the cells up to 100? 19 Insert Form Button 21 Insert ActiveX Button 22 Variables, Do and Loop. 23 What is the advantage of declaring variables as byte, integer or any other? 30 Quiz 3 41 CHAPTER 4 43 What is a Module? 43 How to create a Module 43 Quiz 4 56 CHAPTER 5 57 Review 58 1 68 2 68 3 68 Quiz 5 97 Opening other apps from Excel 99 Sending an Outlook e-mail from Excel: 101 Exercises Solutions 104