How Can I Conduct Exams in MS Excel Using Visual Basic? Seeking Your Advice!

Conducting Exams in MS Excel Using Visual Basic

It is possible to conduct an exam in MS Excel with the help of Visual Basic or macros. Candidates have to write answers for 20 questions. Till now, we were doing it manually, but now my boss is asking us to conduct it in Excel. Please suggest something.

Thanks in advance,

Regards,
Ashwini

Yes, it is possible. You just need to create a form in VB with your questions and then code the other. A simple way is to create a webpage or online test in JavaScript and put it on your server. It is easy; you can even make changes and create many sets. Editing will not be a problem.

Yes, it's simple. First, you need to create a master database of all questions and then connect it to your server. You can do this with VBA code or without VBA code. There are two options: with VBA and without VBA.

Several web pages offer excellent advice on Excel. However, to effectively utilize this advice, you need a certain level of expertise in Excel. You may seek help from experts when conducting examinations.

Could you send me any question paper, for example? I will create and send you a copy of the Excel file (without VBA help).

1. In sheet 2, you have to write your questions.
2. In sheet 1, some formulas will be used in a hidden format and locked so that nobody can access its internal materials.
3. You could send it via email or upload it to your company/organization server.

With VBA:

You will need some codes. Without your question paper, I can guide you on what you want to accomplish.

Regards,
Gaurav Chaturvedi

[Email Removed For Privacy Reasons]
[Phone Number Removed For Privacy Reasons]