Date: Tue, 18 Sep 2007 15:49:06 -0500 (CDT)
   From: Mark Jacobson <jacobson@math-cs.cns.uni.edu>
     To: 810-022-01-fall@uni.edu
Subject: [810-022-01-FALL] Monday handouts on office doors (307 ITT and 338A WRT)

Hi 022 students,

------------------------------------------------------------------------
    In the spring semester, 810:023 Microcomputer Systems will be 2 MWF,
and 810:088 Topics in Computing: Flash Animation will be 12 MWF.
------------------------------------------------------------------------

    Monday handouts on office doors (307 ITT and 338A WRT)

    We did some more advanced Excel VBA, but I did not get it all covered
for the advanced techniques needed to do the more sophisticated Birthday
Macro that:

     1. lets the user specify any number of birthdays between 2 and 364.

     2. colors repeats YELLOW or some other color you like.

     3. shows in an adjacent cell the actual date that was repeated,
        such as 364 is 24-Dec and 33 if 2-Feb and 27 is 27-Jan and so on.

     4. illustrates and uses the Trim, the Str functions

     5. solves a leap year peculiar problem about the year 1900

     6. uses relative cell references and the
        theCell.Offset(row offset, col offset) method within a For Each
        loop that goes through the set of birthdays looking for
        duplicates (repeats).

     We will be in Wright Hall 112 on Wednesday and
     ITT Studio 2 lab in ITT 236 laptop classroom lab on Friday, as usual.

     Mark
------------------------------------------------------------------------
   In the spring semester, 810:023 Microcomputer Systems will be 2 MWF,
     and 810:088 Topics in Computing: Flash Animation will be 12 MWF.
------------------------------------------------------------------------