BMGT 302 Lecture Notes - Lecture 2: Microsoft Excel, Microsoft Visual Studio

• School: University of Maryland
• Department: Business and Management
• Course: BMGT 302
• Professor: Peter Huang

Document Summary

Develop analytical spreadsheet models that support managerial decision making in ms excel via. Obtain hands-on skills using microsoft excel and vba for building state-of-the-art dss. Vb is evolved from basic, beginner"s all-purpose symbolic instruction code. It is a stand-alone programming language part of visual studio. Vba - programming language to automate operations in office applications and customize them to enhance functionality. Can automate recurring/repetitive tasks, execute macro automatically, create own worksheet functions, simplify look and feel, control other office apps. Subroutine/macro- a set of logically related lines of code to accomplish a specific task. Program- all subroutines and macros in an app. Multiple in one line: dim i, j as integer. It should be added into each module: with this at the top line, it will turn blue and then you will have to declare integers and other variables before assigning them values. Dim name as string name = kellen age = 20.