Trigger the next random question?

[qmp]

Hi

I understand the random "=INT(160*RAND())". I'm using this to studing for my drivers test. I have 160 questions with four choice's to answer from. I'm also using VHOOKUP for my data base.

My question is, how do I trigger the next question? The way I have the rand and VHOOKUP together works great, but to goto the next random number I have to click in the formula box to get the next random number to appear. I would like to link it to a button. Any idea's?

Another quick one. How do I put my excel sheet here to show what I have?

thanks...

 

[venkat1926]

i used 10 questions change it

assign this macro to the button and check

Sub test()
Dim j As Integer
j = Int(10 * Rnd())
If j > 0 Then
Range("A" & j + 1).Select
Else
MsgBox "click again"
Exit Sub
End If

End Sub