Select a random row from a worksheet and Display in a different worksheet

[arandhar]

Hi -

I want to do the following:

- I have about 5000 rows (and 3 columns) of data in a worksheet (sheet2)
- Create two buttons "Question" and "Answer" in a worksheet (sheet1)
- When the "Question" button is pressed, column 1 from a random row from sheet2 should be displayed in sheet1
- When "Answer" button is pressed column 2 and 3 of the displayed row should be displayed

I'd appreciate any help!

[Ed_Collins]

Try this:

random question.xlsm

[arandhar]

Thank you! Works like a charm...!!