BMGT 302 Lecture 11: BMGT 302 Lecture 11
23 Aug 2016
School
Department
Course
Professor
Document Summary
Dim employee(100) as string: option base. Option base 1: employee(1) to employee(100: declaration with indexing: Dim employee(1 to 100) as string: dynamic indexing. Dim employee(1 to 10, 1 to 100) as string: three dimension. Find all employees who make a salary greater than 50,000. 9. 3 & 9. 4 table of product info and unit price requested product. 9. 2 keeping track of products sold (productsales. xlsm) 9. 5 and 9. 6, transaction data and number of products sold. Set is a collection of something that has common characteristics. All the indexes start with 0 so for 100 employees, it goes 0-99. ** declaration with indexing is easier than option base. Functions array: use the data type called variant as in dim variant, the first day of the array is &days(0) Prints sun or mon you use the index of the array the first one doesn"t have day 7.
