Macro Programming

1
Macro Programming

• October 2, 2006

2
Advantages of Macro Programming

• Permits Communication Between Spreadsheet and VB
  Program
• All Equations are Entered Directly on Spreadsheet
• No Need to Change VB Program, Good for
  Non-Programmers

3
Disadvantages of Macro Programming

• Cannot Pass Arguments to the Program
• Uses Cell References which Make Changing
  Spreadsheet Very Limited

4
Calculate Area of Circle
Public Sub CircleArea() Note No Arguments are
passed R Cells(2,2) 1st Index Row , 2nd
Index Column Cell B2 Pi 3.14159 Area
PiR2 Cells(2,3)Area Writes Area to
Spreadsheet at Cell C2 End Sub
5
(No Transcript)
6
Generation of Plotting Data

• Plot y Sin(x) from x0 to x30 with points at
  0.3 intervals
• Read in x0, xf, and interval size, output x and y
• Use Spreadsheet to Calculate y

7
(No Transcript)