CS 105 Study Guide - Midterm Guide: Microsoft Excel, Significant Figures, Local Variable

• School: University of Illinois
• Department: Computer Science
• Course: CS 105
• Professor: Kai

Document Summary

Lecture 6: vba for applications: vba= visual basic applications. Allows user to program in microsoft applications: create/improve macros, create user interfaces, make own program, includes an ide, or integrate development environment, uses objects (ex. Cells, ranges, sheets, buttons: making a form button, developer tab > button from form control > drag + drop a button. Assign macros dialog: sub procedures can begin with: public sub. They cannot begin with: public function, private function, private sub, ) events and procedures, events drive procedures, event (something you do) drives a procedure or function (code). Then, excel or vba does something in return: event-driven programming. Value = 9: the equal sign means to take the value on the right side and assign it to the cell on the left side . Lecture 7: message boxes, input boxes, objects: storage of vba, vba code is stored in modules, msgboxprocedure, the msgboxprocedure displays a message to the user.