1. Be able to write (DEFINE) a FUNCTION and know how to USE the function that you wrote. i. I will have you write one function that requires no arguments, and ii. I will have you write another function that has some arguments. Function randInteger(lowest As Integer, highest As Integer) As Integer howmanyvalues = highest - lowest + 1 n = Int(Rnd * howmanyvalues + lowest) randInteger = n End Function Function theRow() As Integer Range("H1").Select Selection.End(xlDown).Select ActiveCell.Offset(1, 0).Range("A1").Select theRow = ActiveCell.Row End Function 2. Know the Cells() method of VBA and how you could use Cells(2, 3).Value instead of Range("C2").Value. Know what the following would do: For i = 2 to 11 Cells(i, 1).Value = i Cells(i, 2).Value = i * i Next i 3. Study the Birthday PowerPoint and understand the final birthday project techniques. 4. Be able to Run Series for something simple, so know: For loops with Step sizes, such as whatRow = 2 For p = Range("E2").Value to Range("F2").Value Step RANGE("G2").Value Cells(whatRow, 10).Value = someRandomNumber(1, p) Cells(whatRow, 11).Value = someRandomNumber(p + 1, 2 * p ) whatRow = whatRow + 1 Next p Range("G2").Value
Run once button, Run n times button, Run series button.
Note: If you misplaced your handout, please pick one up at 307 ITT. I have several copies taped up outside my office door.PREREQUISITE #1: VBA Macros - variations on 23 birthdays problem. Great preparation for the final exam too.
Flash Tutorial Cafe Townsend FMA (Flexible Message Area) resources. We started this on Friday, November 9th.
Spotlight sweeping across a city at night Flash example from 11/02/Friday class.
Flash assignment one is due whenever but before 11/08/Friday. Please email the URL. Also, see the range of test one scores here.
10-24 WEDNESDAY <--------- 3 classes in a row starting on 10/24 10-26 FRIDAY 10-29 MONDAY 11-2 FRIDAY 11-9 FRIDAY 11-16 FRIDAY (last class there)
VIP: Test Study Guide and resources, suggestions and practice.
Did you roll seven, eleven or doubles? How to do FUNCTIONs in Excel VBA.
Review of Monday class handout for 9/17/Monday and preview of certification classes for spring of 2008.
What to read for F L A S H classes review.
Friday, September 14th Rotating Wheel Car example.
Email note: What to study for August 27th and August 29th classes, which will focus on Excel VBA macros.
How to Do Everything with Flash 8 by Bonnie Blake and Doug Sahlin Publisher: McGraw Hill Osbourne (www.osborne.com) - 2006 Cost: $24.99 ($18.99 at Amazon.com) ISBN-10: 0072262451 ISBN-13: 978-0072262452
Microsoft Office Excel 2007 Visual Basic for Applications Step by Step (Paperback with CD-ROM) Cost: $29.99 ($19.79 at Amazon.com) Author: Reed Jacobson Publisher: Microsoft Press (May 16, 2007) ISBN-10: 073562402X ISBN-13: 978-0735624023
Book Description Work at your own pace through the easy numbered steps and practice files on CD, and master the fundamentals for using VBA to create custom software solutions and automating tasks in Excel 2007--no experience required! You'll learn how to automate spreadsheets, write your own functions and procedures, and customize menus and toolbars. You will learn how to write a racing rectangle game in Excel VBA, and a word guessing game like Wheel of Fortune. You will learn how to animate WordArt objects. You'll discover Excel Objects, including workbooks, range objects, graphics, and PivotTables. Plus, you'll learn how to chart data from databases and other information sources.