Workaround for Excel's VBA Rnd function

I am trying to set up a bracket similar in style to the NCAA tournament 64 team bracket to determine a daily lunch champion.

Currently, I have a model which has buttons to click for each round where each champion is decided using an if then statement with the Rnd function. The code looks something like this:

Please Login or Register  to view this content.

It continues with If/Then statements for the remaining 30 "match-ups" in the first round. Unfortunately, using the model this way gives the same "winner" every time you open the model and run it for the first time. Is there a way to better randomize in Excel or should I scrap this approach and do something completely different?

Any and all help will be appreciated. As I'm sure you can tell, I am not a computer programmer by trade.

Originally Posted by MrShorty

You need to put a randomize statement into your code to reseed the random number generator http://msdn.microsoft.com/en-us/libr...ice.14%29.aspx

Haha wow. Working perfectly now. Thanks for the help.