Introduction To Visual Basic For Applications (Vba)

INTRODUCTION TO VISUAL BASIC FOR APPLICATIONS (VBA) LEARNING UNIT 3 INTRODUCTION TO VISUAL BASIC FOR APPLICATIONS (VBA) 3.1 INTRODUCTION, OUTCOME AND ASSESSMENT CRITERIA 3.2 WHY PROGRAMMING LANGUAGES? 3.3 TYPES OF PROGRAMMING STRUCTURES 3.4 THE MACRO RECORDER VS MANUALLY GENERATING VBA CODE 3.5 VALUABLE CODING ADVICE 3.6 ASSIGNING VALUES BY USING VBA 3.7 CHANGING CELL/RANGE FORMATTING PROPERTIES 3.8 EXPLORING MORE PROPERTIES AND ACTIONS IN THE EXCEL OBJECT 3.9 ADDING COMMENTS TO YOUR VBA CODE 3.10 COPYING AND PASTING ACTIONS IN VBA 3.11 ASSIGNING VBA TO A BUTTON OR ICON 3.12 CLOSING REMARKS 3.13 REFERENCES onlystudents 2 | Page 3.1 INTRODUCTION, OUTCOME AND ASSESSMENT CRITERIA In learning unit 1, you learnt to apply computational thinking to business problems. Learning unit 2 covered a more theoretical approach to automation by making use of RPA and robotics. The purpose of learning unit 3 and learning unit 4 is to teach you the skill to build a command that automates a process using Microsoft Visual Basic for Applications (VBA). This will involve writing but also evaluating an algorithm by making use of VBA. In AIN2601, you learnt how to use the macro recorder and you also started to write basic VBA code in the Visual Basic Editor (VBE) using the Excel object. This learning unit will build on the knowledge you obtained in AIN2601. Therefore, it is strongly recommended that you revise your AIN2601 learning units on these aspects before commencing with this learning unit. It is important to reiterate that VBA can assist you in completing a boring routine task much faster and without any errors. This will enable you to focus more on the exciting stuff in your work environment. But let’s dig in by asking: why programming languages? 3.2 WHY PROGRAMMING LANGUAGES? Figure 3