This weeks VBA challenge

Don't worry, we will be spending nearly all day working on our projects on Friday, but just to get us warmed up, here's our weekly VBA challenge!

Finally, you're going to create your own game, based on the vba warmups from the last few weeks! We will need to work together on this one, as it's a bit harder than the previous weeks!

Create a Sub called GuessingGame. Our sub will do the following:

1. Create a new random number between 0 and 100.
2. Ask the user to enter a number.
3. If the user guessed your number correctly, you should use a MsgBox to say "Congratulations!"
4. If the user's guess is higher than your number, your program will respond with a MsgBox saying "Too high", or if it's lower, "Too low"

Once we've got that working, we'll modify our sub with a loop so that our game will keep on asking you to guess the number as long as you don't get it right!

Designing our databases!

With the draft version of our third assignment ready for your feedback, it's time to get together and start designing our databases!

We'll spend some time today together (half an to 1 hour?) helping each other to design our database tables and relationships, using two easy steps:

1. Create a simple list of every bit of data you will need to store (get feedback on this list in case other people come up with other ideas).
2. Group your bits of data into your primary tables!

Simple huh? We'll see what comes out of it!

Improving the AutoFilter in Office 12

In class we've been getting to know both the autofilter and the advanced filter... one of the developers of Excel has just (as in two days ago) given us an example of how the Office12 Excel application will improve Autofilters.

From Autofilter Improvements: much more than just multi-select (sounds easy already ;-)):

Sorting and filtering are two of the most important types of basic analysis that you can do with data. In Excel 12, we have improved sort and filter functionality to better expose common tasks, to make key tasks simple, and to enable scenarios that were not possible in earlier versions. We have done work in AutoFilter, our sort functionality (Data|Sort), and in PivotTables. I will cover the first two (AutoFilter and Sort) in posts this week and PivotTables in a few weeks when I review all our PivotTable work. Today, I will focus on AutoFilter.

Read more...

Weekly VBA Warmup!

Are you ready for the challenge? Conquering these ones will help us to create a simple guessing game next week! Don't forget to use a reference to find the functions you need (such as the MSDN function reference)

1. Create a new Sub called Roundoff that will ask the user for a number, then display the corresponding whole number (the Integer part). For eg., if the user types in 54.342, it will display in return: 54.
2. Create a new Sub called RandomNumber that will display a random number between 0 and 100 each time you run it.