Hi My Dear Seniors M.S Excel Experts Visual Basic Experts, Pls Help Me

Do it is possible to conduct exam in ms excel with the help of visual basic or macro pls guide me. Candidates have to write answers for 20 questions. Till now we were doing manually now my boss is asking us to conduct in excel. Pls suggest me something.
Thanks in Advance,
Ashwini

yes it is possible you just need to create a from in VB with you questions and then coading
the other and simple way is that to create a webpage or online test in javascript and put that in your server it is easy ... even you can make changes ... and can make many sets . Editing will not be a problem

Dear Ashwini,
We have a platform called Violet AMS which will be able to conduct online exams. Do drop me an email at sales@zobble.com if interested.
We can host from 20 to 20k users online.
Regards,
Gunjan
9987317744

Yes , its simple. first u need to make master data base of all questions n then connect it with ur server. U can make it with vba code n without vba code. There is 2 option. With vba, without vba.

Several Web pages are available for excellent advice on excel. But for that to work you need some level of expertise in excel. you may take help of experts for conducting the examination.

Dear Ashwini, Could u send me any question paper for example. I will make and send you a copy of excel file.
( Without VBA Help)
1- In sheet 2- You have to write your questions.
2- In sheet-1- There would be used some formula in hidden format and lock it so that nobody can open its internal materials.
3- You couldsend via mails or upload it on the your company/organization server.
With VBA:
You need some codes. and without your question paper, I can tell you what do u want to do.
Regards,
Gaurav Chaturvedi
Sales Analyst
gauravchaturvedi10@gmail.com
+91-9711983398