Required to create a Visual Basic application to read a list of questions from an Excel sheet.
In Excel sheet there will be three sheets , with questions on them.
In the first column will be the question and the columns next to it will have multiple choice answers.
Application will have to pick a set number of questions from each sheet randomly and generate a questionnaire.
E.g. 10 questions from sheet 1, to create section 1 of test.
10 questions from sheet 2, to create section 2 of test.
10 questions from sheet 3, to create section 3 of test.
The questionnaire will then be presented to the user to answer one question at a time, allowing the user to go back and forth between questions.
After the user answers the entire questionnaire, the application should provide them a mark for each section, and advise them of a failure.
Thereafter it should provide in printable format , the mark achieved as well as the questions they failed to answer correctly.
On acceptance of a bid, the developer will be provided:
The number of sheets for that should be read from to generate the questionnaire (between 3-5).
The number of questions to be pulled from each sheet to generate each section of the questionnaire.
*should this proposal require dramatic changes, these will be provided up front on discussion of a final price.
Hi Eishaweh, thanks for this, it was a very interesting piece of work! I've put together a working sample; check your PM for details and a link.
I am a business analyst with 6 years building custom VBA applications for large trading firms in Ireland.
Looking forward to hearing from you.
R1,958 ZAR in 2 days
4.8 (3 reviews)
3.8
3.8
37 freelancers are bidding on average R3,021 ZAR for this job
Hi, I am sure I can make the application works as you could imagine.
I am an all the time 5 stars awarded freelancer and have never failed even for a single project.
Feel free to check my profile page.
Such jobs are my daily practice. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files and hosting command buttons and other controls if necessary. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards!
Hi Eishaweh,
I have read the description fully and ready to help you. I can build the solution fully Excel based and also an independent application if you want. I have done many application using Excel and VB and VBA. Please check my reviews and feedback to know more about my work quality.
Awaiting for discussion.
Thanks
djain01.
Completion Rate 100%, Rating 5.0 - Expert in VBA.
Just a little clarification: Where will the correct answer be?
(possible solutions are: 1. In a hidden field on the same row; 2. Inside the VBA (fixed answers!!) and 3. on a hidden sheet, containing both sheet number and row number.)
Hope you choose me...
Dear Sir,
I am very interested in generating the test you are asking for project, and I'm sure that I can completely satisfy your demands.
Kind regards, Dimitris M.
Hi Eishaweh,
I've 13 years experience in VBA Macros in Excel and in my last 2nd company I've did a questionnarie project like this, hope I could do this with your requirement and clarity ASAP.
Thanks, Sriram.
Hi ,
I have an experience on Excel-VB development when i am ST-Ericsson ,i am sure that i can able to develop that
app reading from excel and conducting examination as you wish .I can provide you the front app in web format or windos or Console .Please consider my bid we can have a better price discussion .
Thanks .
Y Hariprasad .