As of 11:47 PM Friday 12/08 - this study guide is DONE
math-cs:~/web> date Fri Dec 8 22:46:48 CST 2006
One type of question you can definitely expect is that of modifying some VBA code that is in front of you so that it does something slightly different from what it does, and/or so it does something in a different way than it did it before.
For example, the Cells(r, c) property is something I just learned this fall. You can use the Cells() like this to modify the 23 birthday's macro code: Yellow and No Fill and using Cells(row, column) for another approach to Coloring the repeated birthday's YELLOW.
As you go through the PowerPoint slides again, and the Notes for some of the slides, you should be able to get a fairly deep appreciation of the techniques used.
Notice also the evolution of the application from displaying Repeat or no in column B, to showing the YELLOW for repeated birthdays and allowing the user to run the macro 100s of times and see the overall count of how many repeats. (48 out of 100, or 321 out of 600 for example).
Could you put the actual mm/dd month/day date in column B when there is a repeated birthday in column A that is colored YELLOW?
Birthday MM/DD if repeat 3 19 29 35 45 45 14-Feb <------------ or 2/14 depending on which Excel Format 60 (Look for Dinosaur Treats ... in 810:023 on or near 2/14/2007) 359 359 25-Dec <------------ or 12/25 and Merry Christmas to you too! 361 math-cs:~/web> cal 12 2006 December 2006 Su Mo Tu We Th Fr Sa 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 math-cs:~/web> math-cs:~/web> cal -j 12 2006 December 2006 Su Mo Tu We Th Fr Sa 335 336 <--------- Julian dates 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365
Here is an example you received as an email note, and is the function I meant to ask on test two, but accidently did not demonstrate the 3rd argument as whereToStop, cause I was too used to it as howMany (from the Mid() function which is built into Visual Basic for Applications.
Function SliceOfFromWhereToWhere(theString As String, _ whereToStart As Integer, _ whereToStop As Integer) As String answer = "" For i = whereToStart To whereToStop answer = answer & Mid(theString, i, 1) Next i SliceOfFromWhereToWhere = answer End Function