Designing a Quiz sheet.

[Fortune117]

Hey guys,

Wasnt sure where to put this so I finally decided on here. I've been given a task by my local pub to design a quiz sheet as the ones that they are using at the moment are costing them alot as they need to pay for the printing AND to use the name. I have a basic idea of what I need but im stuck on one particular factor of the build and that is the randomly generated numbers.

What I have so far is 21 boxes, and in these boxes I need 21 numbers to be randomly generated whenever a quiz sheet is printed. The quiz sheets will be printed in blocks of 1000.

Is there a macro I could use? Or what I was thinking of was using the mail merge feature, but would that randomize the numbers? or just have them in order.

Ill also be developing a VB program to go along with these sheets to calculate the total earnings etc after printing costs so nobodys walking away with money in their pocket but im quite sure im capiable of this.

Any help?

Also:If this isnt in the right section could a mod please move it? Thanks.

-Fortune

[Fortune117]

Update:

Went through my college book for VB and funnily enough it had a program in it to generate a random number. So far I have


Sub random_number()

random_number Macro


Dim MyValue, min, max
max= 21
min = 1

Randomize
MyValue2 = Int((max - min + 1) * Rnd + min)
Selection.TypeText Text:=MyValue2

End Sub

If I put all of the text boxes to '0' and put an if statement in that macro would it automatically change all of the numbers?