Date: Fri, 31 Aug 2007 11:48:20 -0500 (CDT) From: Mark Jacobson To: 810-022-01-fall@uni.edu Subject: [810-022-01-FALL] First Macro Excel VBA assignment... Hi 022 students, The first Excel VBA macro assignment will be to create a version of the Birthday macro that does the following: 1. It simulates groups of 19 people instead of groups of 23. 2. It has a button to run the macro once. 3. It has a button to run the macro 200 times. 4. It has a button to reset the counters back to 0. 5. It uses a macro to Convert Formulas to Values to get rid of the =INT(RAND()*365 + 1) formula. You can show me this macro at the beginning or at the end of one of our lab classes, or stop by the office to show it to me. It will be due by the end of Labor Day holiday week, which would be Friday, September 7th. Also, please turn in a screen snapshot of your Excel user interface, and turn in a printout of your Macro code. Mark