Chapter 2.3: VBA Primer - Northwestern University
Chapter 2.3: VBA Primer
?Barry L. Nelson Northwestern University
December 2012
1
Visual Basic for Applications
? VBA a significant subset of the stand-alone Visual Basic programming language
? It is integrated into Microsoft Office applications (and others)
? It is the macro language of Excel ? You can add
? Forms for dialog boxes with user input ? Modules containing procedures this lecture ? Class Modules for object definitions later
2
VBA & Excel for discrete-event simulation
? Advantages
? VBA is easy to learn and available almost everywhere ? VBA is a full-featured programming language so what you
learn translates directly to C++, Java, etc. ? You have access to Excel functions for computation and
Excel itself for storing and analyzing outputs
? Disadvantages
? VBA is interpreted, not compiled, so execution is slow ? Excel functions can be buggy
3
Accessing VBA in Excel 2010+
? You launch the Visual Basic Editor from the Developer Tab.
? If you don't have a Developer Tab in the Ribbon, then go to the File, Options, and add the "Developer" tab to the ribbon.
4
Property Inspector
Project Explorer
Modules are a convenient way to organize code
Declarations made here are global; all other code must be in a Sub or Function
Code Window: This is where you will write your simulation programs
5
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- chapter 2 3 vba primer northwestern university
- vba programming data visualization part 2
- a guide to excel and fme safe software
- macros and functions
- rit vba api tutorial university of toronto
- 239 excel keyboard shortcuts
- test your excel vba skills 8 engineering exercises
- vba cheat sheets automate excel
- creating a slider in excel
- an excel visual basic for applications vba programming
Related searches
- chapter 2 developmental psychology quizlet
- medical terminology chapter 2 terms
- physics chapter 2 practice test
- northwestern university in chicago il
- psychology chapter 2 quizlet
- northwestern university executive programs
- northwestern university linguistics
- northwestern university digital marketing
- northwestern university executive education
- discover 1 2 3 4 checking 1 2 3 4 account
- discover 1 2 3 4 checking 1 2 3 4 account 1 2
- 2 3 2 pltw digital electronics answer key