Samenvatting

Summary Ain3701 b0 ls

0 keer verkocht

Vak
Ain3701 b0 ls04 003 2402

Instelling
Ain3701 B0 Ls04 003 2402

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 tea...

[Meer zien]

Voorbeeld 3 van de 21 pagina's

Bekijk voorbeeld

Geupload op 1 juli 2023
Aantal pagina's 21
Geschreven in 2022/2023
Type Samenvatting

ain3701 b0 ls04 003 2402

Volgen

examthreads

Lid sinds 1 jaar 33 documenten verkocht

€3,44

In winkelwagen

Op verlanglijstje

100% tevredenheidsgarantie
Direct beschikbaar na je betaling
Lees online óf als PDF
Geen vaste maandelijkse kosten

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

1|P a g e

,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.1: Microsoft Office 365 Stock Images

Fac mihi aliquid capulus, quaeso.

Do you understand what I am saying?

I think most of you do not know what I am instructing you to do here �.

Now let’s run this through a machine translator:

2|P a g e

, “Fac mihi aliquid capulus, quaeso” is Latin and means “Make me some coffee, please”. Now you
understand the instruction given and will perform the task by making me some coffee.

But what did you need to perform this task? You had the instruction in Latin, a Latin translator and
the instruction given in a language you could understand, which was English.

Our communication with computers is the same. Computers communicate in binary code (a
language consisting of 0s and 1s). Let’s illustrate this: a computer wants to communicate to you and
displays the following: 01001000 01100101 01101100 01101100 01101111 00100001. According to
Zych (2015), the computer is telling you “Hello”. If you want to learn more about binary code, you
can read the article by Zych by clicking here. Note that this article is not part of the syllabus and
therefore not examinable.

Just like in the case with the Latin phrase, we need interpreters to interpret instructions and
communications between us and computers. Programming languages act as these interpreters. So, if
I tell a programming language to give a computer an instruction to copy a range of cells in a sheet of
a spreadsheet and to copy it to another workbook, the computer will comply. Luckily, I do not have
to communicate this directly to the computer using 0s and 1s, as you get different interpreters,
which in this case are your programming languages. The problem is that each programming language
has its own rules (or syntax). We need to understand the rules so that we can get the computing
results we want. Essentially, for us to communicate efficiently with a computer we need to know the
programming language. There are different programming languages on the market. Popular
languages are Java, R, Python, C, C++ and Visual Basic for Applications (VBA). As you were introduced
to a Microsoft-based solution called Microsoft Excel (Excel) in AIN1501 and AIN2601, we will teach
you to create a solution using VBA.

Note that VBA is not available on the web-version of Microsoft Excel. You will need to use the
desktop version of Microsoft Excel 365 to work with VBA.

Next, we are going to explore the different types of programming structures.

3.3 DIFFERENT TYPES OF PROGRAMMING STRUCTURES

In learning unit 1, you learnt about algorithms. Most programming languages make use of
sequences, selections, and loops. It is important to understand when and how to make use of these
different coding methods as you are going to use them when writing the code for VBA. Watch the
video by GCFGlobal (LearnFree.org) that illustrates these concepts by clicking here.

3|P a g e

Dit zijn jouw voordelen als je samenvattingen koopt bij Stuvia:

Bewezen kwaliteit door reviews

Studenten hebben al meer dan 850.000 samenvattingen beoordeeld. Zo weet jij zeker dat je de beste keuze maakt!

In een paar klikken geregeld

Geen gedoe — betaal gewoon eenmalig met iDeal, creditcard of je Stuvia-tegoed en je bent klaar. Geen abonnement nodig.

Direct to-the-point

Studenten maken samenvattingen voor studenten. Dat betekent: actuele inhoud waar jij écht wat aan hebt. Geen overbodige details!

Veelgestelde vragen

Wat krijg ik als ik dit document koop?

Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.

Tevredenheidsgarantie: hoe werkt dat?

Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.

Van wie koop ik deze samenvatting?

Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper examthreads. Stuvia faciliteert de betaling aan de verkoper.

Zit ik meteen vast aan een abonnement?

Nee, je koopt alleen deze samenvatting voor €3,44. Je zit daarna nergens aan vast.

Is Stuvia te vertrouwen?

4,6 sterren op Google & Trustpilot (+1000 reviews)

Afgelopen 30 dagen zijn er 69411 samenvattingen verkocht

Opgericht in 2010, al 15 jaar dé plek om samenvattingen te kopen

Begin nu gratis

Samenvatting

Summary Ain3701 b0 ls

Document informatie

Onderwerpen

Geschreven voor

Verkoper

Ontvangen beoordelingen

Voorbeeld van de inhoud