Excel Macros Section 2: VBA (Macros) VocabularyIn the first section you have discovered the Visual Basic Editor and the Macro Recorder. You have learned how to communicate with Excel and how to test your VBA procedures (Macros). In this second section you will discover the programming language itself: VBA or Visual Basic for Application. You will learn the vocabulary to ask anything from Excel. After section 2 you will be able to develop small and useful macros and even very complex programs. Lesson 11: VBA Coding Tips and General VocabularyLesson 12: Working with ErrorsLesson 13: Working with the ApplicationLesson 14: Working with WorkbooksLesson 15: Working with WorksheetsLesson 16: Ranges, Cells, Rows and ColumnsLesson 17: Message Boxes in VBA for ExcelLesson 18: Excel VBA Vocabulary to Filter and Sort DataLesson 19: Working with VariablesLesson 20: Working with StatementsLesson 21: Working with FunctionsLesson 22: Working with SQL and External DataLesson 23: Working with other programs in VBA for Excel
|
||||||||