CPSC 203 Lecture Notes - Lecture 6: Current Contents

• School: University of Calgary
• Department: Computer Science
• Course: CPSC 203
• Professor: James Roger Tam

Document Summary

Exercise 20output macro (cid:494) (cid:494) (cid:494) (cid:494) (cid:494) (cid:494) message box (cid:523)(cid:498)(cid:499)(cid:524) No (cid:498)(cid:499) it will be treated as a memory location. As you type in the name of the vb functions you will see visual hints about the arguments for the function. Think of vba variables like a mail slot in memory. Unlike an actual mail slot computer variables can only hold on piece of information. Common mistakes: assigning values from one variable does not link them is gone and 2 shows up. 1: copy the current contents if num1 to num2, assign the constant 2 into location num 1. Name= )nputbox (cid:523)(cid:498)what(cid:495)s your name(cid:499), (cid:498)getting personal: name(cid:499)(cid:524) Age= )nputbox (cid:523)(cid:498)what(cid:495)s your age(cid:499), (cid:498)getting personal: age(cid:499)(cid:524) Msgbox (cid:523)name & (cid:498)your age in dog years is (cid:498)& dogage) Similar to everyday objects vba-objects have properties and actions. Eg word document, information would the name of the doc etc.