VBA - randomise 15 question from the pool of 80-90 questions for user to selected

**tushar@excel** · 03-30-2008, 06:47 AM

Hi All,

I have a requirement -
I am creating a flow of a complex program so that others don't face problem while comprehending the program. Till this part its easy, but then i want to add some more feature.
I want to have a test feature ie if a user click take test tab then my macro should send randomly selected 15 question from the pool of 80-90 questions and the user has to fill the answers.
Another thing which i want to add is to lock the macro from viewing or updation by any other user.

Regards,
Tushar

**mudraker** · 03-30-2008, 08:25 AM

This is an example of generating random questions that are stored in a1 to a90
It loops 15 times

There is no checking to ensure each question has not been asked previously

The macro will exit if you Click the Cancel button

Please Login or Register  to view this content.

For protection look at VBA editor > Tools > VBAproject > Protection Tab

VBA - randomise 15 question from the pool of 80-90 questions for user to selected

LinkBack

Thread Tools

Rate This Thread

Display

VBA - randomise 15 question from the pool of 80-90 questions for user to selected

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions