LinkBack URL
About LinkBacks
Good morning guys,
Is it possible to shuffle entries inside the dropdown list?
Like everytime i close and then open the excel, the dropdown list will shuffle itself.
Thank you
1_zpsuev2kns5.png
http://www.filedropper.com/final-test_1
Good morning guys,
Is it possible to shuffle entries inside the dropdown list?
Like everytime i close and then open the excel, the dropdown list will shuffle itself.
Thank you
1_zpsuev2kns5.png
http://www.filedropper.com/final-test_1
Last edited by shaterroi; 12-16-2015 at 08:18 PM.
Help guys?
Is there any macro for this sir?
Help please sir
You need to post the workbook onto this site.
ViewPic
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
I attached it now already sirOriginally Posted by skywriter
I really need help on this
You really need to have some patience.
So the following code goes in the sheet module for the questions sheet and the second code goes in a regular module.
The code will shuffle the order after an item is picked in the drop down.
So open the drop down make a choice and the next time you open it the order will be different.
I have attached your sheet with the code installed and working.
Please Login or Register to view this content.Please Login or Register to view this content.
Last edited by skywriter; 12-17-2015 at 02:04 AM.
Sorry sir.You really need to have some patience.
So the following code goes in the sheet module for the questions sheet and the second code goes in a regular module.
The code will shuffle the order after an item is picked in the drop down.
So open the drop down make a choice and the next time you open it the order will be different.
I have attached your sheet with the code installed and working.
Please Login or Register to view this content.Please Login or Register to view this content.
Thank you for the code sir but there is a problem.
Everytime i chose the correct answer on the first try, it says wrong. But on the second time it says correct.
You need to keep on clicking the correct answer before it says correct answer.
Thankyou again sir
Last edited by shaterroi; 12-17-2015 at 02:20 AM.
That's because you have a formula in that column that points to a particular cell on the answer list, you weren't aware of that?
You need to make an answer list and then perhaps have a formula that checks the choice made in the drop down list.
Last edited by skywriter; 12-17-2015 at 02:29 AM.
Just the first time in running macros sir.
Any advice sir on how do i do that?
Sure let say in cell H2 of the Questions sheet you put the correct answer for the question in B2. Let's for the sake of argument say that the answer is "Dead-Reckoning", which I think it is.
In cell F2 you would have the following formula:
Formula:
Please Login or Register to view this content.
So in the H column you would put all the right answers and you can then hide that column and protect the sheet so no one can select or unhide that column.
Last edited by skywriter; 12-17-2015 at 02:40 AM.
Thank you so much sir. I got it alreadySure let say in cell H2 of the Questions sheet you put the correct answer for the question in B2. Let's for the sake of argument say that the answer is "Dead-Reckoning", which I think it is.
In cell F2 you would have the following formula:
Formula:Please Login or Register to view this content.
So in the H column you would put all the right answers and you can then hide that column and protect the sheet so no one can select or unhide that column.
One more thing sir, is there a way in which i can edit and make the dropdown list large enough?
I guess you can't change the font size if that's what you are after.
See this page.
Thank you sir!
You're welcome.
Please click the Thread Tools drop down box above your first post and choose solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks