Exam Application Form with Timer | Step by Step Tutorial
ฝัง
- เผยแพร่เมื่อ 18 ก.ค. 2020
- #UserForm #VBA
Hello Friends,
In this video you will learn how to develop an Examination Application Form in Excel VBA. We have given the User ID and Password to login the application and have used the Timer for each Question.
Download the practice file from below given link:
www.pk-anexcelexpert.com/exam...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
WWW.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Pinterest:
/ pkanexcelexpert
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-matic.com/refer/...
Thanks pk of this good video.this video very help to me.🙏🙏🙏🙏🙏🙂🙂🙂🙂🙂🙂
Thanks fo your valuable feedback
One of the best video on TH-cam, PK sir you are a genius.. thankyou my Dronacharya...
Diversified innovations. What an effort, sirji.
PK, frankly I really like your files and videos that can make me learn and expand more VBA code knowledge.
Thanks for your valuable feedback
Superb, Great Work buddy. Keep up the good work.👍
Thank you so much 😀
Awesome application sir... It is very useful for competitive exams practise... Awesome... 👌👌👌👌
Thank Pk This Is Very helpfull for me.......
Thanks for your valuable feedback
Excelente trabajo, muchas gracias por compartir
I must say you are the best one in youtube channel who gives such a valuable knowledge for free. May GOD bless you sir. Looking forward to see some more new thoughts from your knowledge treasure.. Sir i just want to know if we can restrict one userform in one pc only...it should not be used any other pc... after you logged in one pc....waiting for your advice
Just Fantastic video sir, Lot to learn and implement in our projects
Thanks for your valuable feedback
Hi PK sir, I would like to thank you for your time which you spend for us. This is great sir, I have never missed your tutorial videos.
Thanks for your valuable feedback
Hello PK. I am freelancer, Created several automatons in Excel for big companies. I must say your videos are really superb. And I admit recently i did one project and i applied few techniques which i learned from your video. Great work buddy..... Big thumbs up.
Thanks for your valuable feedback
Awsm knowledge of XLS u have...
Thanks for your valuable feedback
Waoooo. Fantastic. Amazing. You are great. You are a genius. Sir, Thank you so much for uploading this type of video.
Thanks for your valuable feedback
Always outstanding and good work sir
Thanks for your valuable feedback
I gets your new information about PK Has created this video.
This such video is like and exam form and the frame changes into an dynamic exam form.
Your an excel expert.
Fantastic.
Video is good.
Outstanding PK sir. How can find out these types of thinking? Really I'm big fan you. I'm watching your every video tutorials.
This is so useful for me. Thank you
Most welcome
How long have I been looking for similar videos very good video outstanding 👍
nice project sir.
Thanks for your valuable feedback
Every time you come up with great one.
Can we expect a full playlist on pawer query DAX & and full tutorial on tableau.
Good PK.
A great and genius video
Thanks for your valuable feedback
I look forward to your video every Sunday.I have learned a lot from your video tutorials. Thanks for that 😊😊😊
Thanks for your valuable feedback
@@PKAnExcelExpert sir ap kya excel, vba, power bi training detay hain?
@@PKAnExcelExpert main advanced excel, vba sikhna chata hu. App kya channel kya video bohot help karta hain
Sooperbbbb and Very useful
Thanks for your valuable feedback
Grazie mille!
Molto gradito
Thank you for this
Most welcome
First viewer and first like
Good videos
Thanks for your valuable feedback
Thanks sir
Welcome
Awesome..
Thanks for your valuable feedback
I am lucky to know you^^
Thanks for your valuable feedback
awesome
Thanks for your valuable feedback
Hi,
Is it possible to change the timer part to entire set of questions selected?
I want the VBA to allow the admin to set the timer of 30 mins so that the person taking the exam do not have to answer the question within the timer set for each question.
Instead take 30 mins to answer
Thanks for the tutorial. Can we have a separate video to show how to make a timer ⏱ for example: based on today(), calculate the business days left until end of particular current month.
Great suggestion! I have already created a video on timer
th-cam.com/video/2IqNX1OKszM/w-d-xo.html
👏👏👏
Thanks
Hi
Very nice video
आप हिंदी में भी video किजीये सर
Thanks for this video. Please if I want to use this for multiple subjects, how do I go about it? Will I just duplicate one into the number of subjects I want to do or there is a way to do it with VBA? Thanks for your response in advance
Thanks for this video.
Please, can you help dropping the codes used in this video
Nice one, great job Mr. PK. I also created an Exam Template with a timer but when I press = sign the timer has stopped then again resume after pressing the enter key. Can you please help me to fix the same.
Thanks a lot sir
Can I have the password to unprotect the setting worksheet and the workbook
1st Comment
Thanks
Hi...
Is this possible to mark vlookup in ms access from excel vba command button on click...
Sir i need to add image file in the options say some free hand sketch as option is it possible to add in the answers as an object. please give me some suggestions
Also, can it be possible to assign certain points for different options? For example, Option 1 is 3 points, Option 2 is 4 points, Option 3 is 2 points, and so on?
Yes, we can. I will create it in the next version
This is indeed an amazing program. But is it possible to insert photo, audio or even a video on a question? How about inserting photo audio or video on the options? Thank you very much.
I will try to add these features in next version
@@PKAnExcelExpert Thank you.
Does this work on mobile?
Hey PK, please share a video on how to connect ms excel to ms access... If I have created a user form in excel and that data i need to store in Ms access... By linking it is easy...but through vba code please tell me
useful project....i installed pk untility version 2.0 but am not getting options for using ....how i will get those options for use...???(2.0 is installed and displayed on my Customized ribbon...but it is not to use those options)
Sir, please how an one linked the examination application for more a user within a loca area network( i mean without using the internet. Thanks
Nice work. I am your great fun. Please how can someone make the timer run all through the exams rather than running in each question? That is, I want to set the timer to keep running while answering all the questions and to warning me or stop at the end of the last questions. Kindly assist, Thanks.
Hello PK Sir.
There is some problem.
In the test file even after answering all questions within time randomly less answers are being registered for different users out of the total questions.
There is no pattern though.
Thank you for the posts. I am getting an array error at this line '.UsedRange.Sort key1:=.Range("J1"), order1:=xlAscending, Header:=xlYes in the sorting sub. I cant seem to find the issue.
NM, I got it.. I was populating my question sheet with a Filter function. My Question DB has different levels of Q's. Just created a CNP macro and it worked.
Sir need ur help in this exam code when user completed the exam only 6 questions answers recorded in answer sheet remain not recorded
Hi sir, I have download the excel file,
I am not able to open the VBA sheet to see the script. Even I want to prepare the same thing. However I have lot of questions, which I need add reset the settings. However I couldn't. Could you please help me on that
Dear PK sir as per your video i have creat fream but not set coding plz share link how to set coding
एक्सेल के भगवान
superb sir,
but there is a bug after one exam alway show msg that exam is already completed for all users.
Hello
How I can put a single timer for the duration of the examination instead of question specific alloted time?
Yes we can do that. we need to make the changes accordingly. I will try to consider this in next version
Thank you for your relentless efforts but sir I am still waiting for the ability to put a single timer for the duration of the exams sir. Thanks in anticipation
Hi,
Really very useful Template. But facing some issue while working on it. Need technical support. Pl share the contact details
Sir
get data from userform into table
Can you have a question with multiple answers
What is the next step once fream done how to coding or link each other
Agr long question. Ka bnana ho
Hi Sir how to show results instantly to the user ??
how to add picture in options ?
Hello PK, Where can i get a copy of your Codes?
You can download it from below webpage. This link has been given in video description also
www.pk-anexcelexpert.com/exam-application-form-with-timer/
@@PKAnExcelExpert yes but in the video, some part of the codes are not visible. I'm trying to create similar game and trying to understand the codes too.
@@PKAnExcelExpert nevermind bro, i found it hhahahaha i was so silly
What if I have more than 1 quiz, how do I setup a Main Menu, and select which quiz I want?
there is something missing that is if some one is new and watching first time so he can find that how call launch exam???
Would like to know this too. How to activate the launch exam button on sheet one
Do you offer private help
Please email us at info@PK-AnExcelExpert.com