



















Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
An introduction to Visual Basic for Applications (VBA) in Excel, focusing on updating the company's data storage format for Bruin Health Insurance. The objective is to write a VBA macro to create new rows for renewed memberships and format the data accordingly. enabling the Developer tab, getting started with VBA, VBA in Microsoft Excel, subroutines, functions, macro recorder, variables, arrays, IF statements, WHILE and FOR loops, FOR EACH loops, message boxes, and debugging tools.
Typology: Study notes
1 / 27
This page cannot be seen from the preview
Don't miss anything!
Note: Slides will be posted on our website after this meeting
BACKGROUND
OBJECTIVE
OUR GOAL
ENABLING THE DEVELOPER TAB File Option Customize Ribbon Check “Developer”
THE VBA ENVIRONMENT Multiple ways to open the VBA Editor:
GETTING STARTED A module is where you can write VBA code Type your code here
GETTING STARTED
VBA IN MICROSOFT EXCEL
SUBROUTINES
FUNCTIONS
MACRO RECORDER
VARIABLES
ARRAYS