Microsoft Excel Macros & Excel Solver ( IENG 490 ). Spring :(201 3 -201 4 ) Research Assistants: Arman Nedjati & Mahmoud Golabi. Excel Solver. Example1. Example2. Example2. Contents of Macros. Introduction to Macro Introduction to Visual Basic for Application Recording a Macro
Spring:(2013-2014)Research Assistants:ArmanNedjati & Mahmoud Golabi
Working with Excel while recording the macro
Using the Form Controls select a GUI element and by mouse-click place it on the frame
The Cell and click on button
Initialize a spreadsheet and fill five vertical cells with numbers. Select the cell to the right
Start macro-recording and modify
Input formula in cell C2 and then stop macro-recording.
Test the macro by filling other five cells with numbers, then select the cell to the right
and then click shortcut-key. (we had chosen [Ctrl-a] )
Click [Alt-F11] to access VBA module
Writing a subroutine to solve a set of linear equations while allowing the user to input cell-range.
Step 1. Click [Alt-F11] to open the Visual Basic Editor.
Step 2. Select [Insert][Module].
Step 3. Type in the following code:
Step 4. Go back to the Excel workbook by clicking [Alt-F11] once more. Then click [Alt-F8] to change the macro options and select shortcut key (plus add description if desired).
Step 5. Test the macro. First prepare the spreadsheet with a matrix which will be treated as matrix A and column of cells to be treated as vector b. Then run the macro.