Event box

Learn VBA (Visual Basic for Applications)

Learn VBA (Visual Basic for Applications)

Ordinary users and developers can automate Office applications. Record macros, automate repetitive actions or even build an entirely new application.

Related LibGuide: Properties Data for Chemicals & Materials by Erin Rowley

Friday, July 12, 2019
9:00am - 3:00pm
2101 SMBS
Downtown Campus
  All Workshops  
Registration has closed.

This workshop is for people who have little to no experience with programming computers but have some familiarity an Office application. We’re not going to make you a computer programming expert. This is an introductory level workshop. We think you will be able to use VBA to accomplish simple, useful actions after attending this workshop. Some attendees will quickly advance to a higher skill level on their own.

If you use any of these Office applications, you are a good candidate for learning VBA. You can use your VBA skills with all of these programs:
Microsoft Word
Microsoft Excel
Microsoft PowerPoint
Microsoft Outlook (Windows only)
Microsoft Project
Microsoft Access
OpenOffice Calc
LibreOffice Calc

After attending this workshop, you will know
Enough about code to get started
How to open and use the Visual Basic Editor
How to control application and document properties
How to write and run your first “Hello World” program
How to make and run macros
How to record macros
How to make your own new worksheet functions in Excel and Calc

There will be a 30 minute lunch break at 11:30am

Workshops are offered at no charge to UB faculty, staff, students and alumni.

Please remember to bring your own device to the workshop. The classroom (2101 Jacobs Downtown Medical Center) does not have workstations. You must have chip key card access to the building in order to attend this workshop.

Co-sponsored by The Graduate School.

Event Organizer

Profile photo of James Gordon
James Gordon

More events like this...