This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: 3. When the button is clicked new totals and averages will appear below (rows 16 a 4. Averages should be reported with one digit to the right of the decimal. Avg and to 5. Note that VBA code will not know ahead of time how many months of data are pr 6. Choose a non-white background color for the cells in row 16 and choose a non-b 7. Your first executable statement should be Range("16:17").Clear 8. Let the Font Name be Calibri and font size be 11 for rows 16 and 17. and 17). totals should have commas for 1000's. resent black font color for 17....
View Full Document
- Spring '08