Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday.
For details you can visit our website: www.familycomputerclub.com
Josh wants to know how to create a test paper from a question bank using Excel VBA. He wants a random test paper to be created with unique questions. We use the random function to generate a number. We also ensure that no duplicate number is used by generating another number if the same number is generated by Excel using the countif function.This number is then used to get a question from Sheet2 into Sheet1. In this manner we ensure no duplicates in our question test paper and a truly randomly generated question paper.
We also learn how to write a lot of interesting and useful VBA code.
Details with complete VBA code: www.familycomputerclub.com/Generate-Test-Paper-from-Question-Bank-Using-Excel-VBA.html