Ateneo - UPO

VBA (Visual Basic for Applications) is a language related to Visual Basic that can only run through a host application (Excel, in our case).

Using VBA, we can do almost anything imaginable with Excel.

In the elective course you will learn how to use VBA and build programs that can interact with the end user by building UserForm.

The course material is freely available on the web. In particular:
* for an introduction to VBA:
https://www.excel-pratique.com/en/vba/introduction
* for an introduction to building Userform:
https://www.excel-easy.com/vba/userform.html
The relevant parts are:
Part VI: Automating Excel - Chapters 42-48.

This short course will extend your knowledge of Excel beyond Microsoft Excel: Level 1 and provide you with the skills and knowledge to produce more effective and productive workbooks.

This Elective course (15 hours) assumes no prior programming knowledge and builds a solid foundation of the skills and knowledge required to learn to read and write industrial VBA code in Microsoft Excel. You will gain an understanding of the background knowledge (and more) a programmer should have, in order to successfully learn to program Excel VBA macros and functions.

Good working knowledge of Excel.

Assumes prior skill and knowledge required to create, edit, print and chart simple worksheets, as well as understand ranges and the copying process.

You should be also familiar with the basic functions of a computer operating system such as navigating the environment using a mouse and keyboard, starting applications, copying and pasting objects, formatting text, creating folders, opening and saving files, familiarity with the accessing the Internet and web browsers.

Lectures require the student to have access to VBA Excel and to be able to create USERFORM.

Teaching instructions and materials are specifically tailored to Windows PC users.

Teaching instructions and materials are specifically tailored to Windows PC users.

Face-to-face classes
These classes run in a computer lab and you do not need to bring your own device.

Online classes
If you are attending an online class, you will need your own device.

Students with physical disabilities, Learning Disabilities or Special Education Needs can request specific services and tools via the Staff Sviluppo e Coordinamento Carriere e Servizi alle Studentesse e agli Studenti, consulting the University webpage: https://www.uniupo.it/en/services/servicesstudents-physical-or-learning-disabilities Students with disabilities, learning disabilities or special education needs, once they have contacted the University Staff, can refer to the tutor in charge of the course to define the examination modalities.

The student must present a short report and discuss the solution of a real case that requires the construction of a User Form and the use of VBA.
Group projects (maximum 3 students per group) is allowed.

1. Introduction
Start Up
First Macro
2. Sheets and cells
3. Variables
4. Conditions
5. Loops
6. Procedures and functions
7. Dialog boxes
8. Forms and controls
9. Arrays
10. Web Scraping
11. VBA tips

Intended audience
Designed for existing users of Excel who would like to expand their skills and knowledge and learn more of the techniques associated with creating better and more productive workbooks.

Master Microsoft Excel from Beginner to Intermediate-Advanced
Build a solid understanding on the Basics of Microsoft Excel
Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA.

Outcomes
By the end of this course, you should be able to have a working knowledge about the use of VBA and the use of Userforms.

In particular, you will be able to:
discuss the elements of human logic manifest in Excel’s user interface, and some of the ways those elements manifest in Excel VBA
implement those elements in VBA functions and VBA macros for Excel
describe the Microsoft Excel Object Model and VBA concepts
begin to catch errors with basic debugging.