EngineeringProblemSolvingCourse.pptVIP

Using Visual Basic for Applications VBA Jake Blanchard University of Wisconsin Spring 2010 VBA Macros Macros allow one to add significant power to Excel They are small programs that can be called from a spreadsheet You can create functions or subroutines If you want to get fancy, you can add a user interface as well Using Macros Macros are written in a Basic-like language called Visual Basic for Applications Excel comes with a separate macro editor To create a macro, go to Tools/Macro/Visual Basic Editor, then within the Editor go to Insert/Module You should get this... Creating a Function S