| COURSE: | INFORMATION SYSTEMS 262 Visual BASIC for Excel |
| PROFESSOR: | DR. MABEL T. KUNG |
| OFFICE: | LH 517 |
| OFFICE HRS: | Saturday 12:30 – 1:30 PM |
| PHONES: | (714) 278-3077 (MY OFFICE) (714) 278-2221 (SECRETARY) |
| EMAIL: | mkung@fullerton.edu |
| TEXT: | Heitzman, William, Writing Visual BASIC in Excel 97, Titan Bookstore, Custom Publishing. 1999 |
| GRADING: | EXAM 100% |
| EXAM DATE: | June 26 |
COURSE OUTLINE:
Introduction to Visual BASIC in Microsoft Excel
Data Tables, Visual BASIC for applications
Creating Macros to Automate Data Entry
Visual BASIC Modules, Cell Locations
Variables, Arithmetic Operators, Macros
Interacting with the program and Decision Making
Looping
Sub Procedures and Arrays