Reset All Data Validation Lists
I have looked thru and tried several of the other offers of advice and still cannot get this to work. I am new to excel and am not sure if I have set it up correctly. I have my sheet, and inserted a reset button using the insert - Active X controls - button. I have added the macro using this text in it that another member suggested. Help is very much appreciated.
Please Login or Register to view this content.
Last edited by cat3rn; 12-24-2013 at 01:08 AM. Reason: to comply with the rules
I have also tried this.
Please Login or Register to view this content.
Last edited by cat3rn; 12-24-2013 at 01:08 AM. Reason: to comply with the rules
Your reset button (click) doesn't do anything. You need to call the code to reset the DV lists.
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
So should it read like this?
If you could add it to the above file then re-upload it that would be great.Please Login or Register to view this content.
Last edited by cat3rn; 12-24-2013 at 01:07 AM. Reason: to comply with the rules
Yes, that's what it should look like and no, I can't add it to the file and upload. I'm on holiday, away from my computer and using an iPad.
There's only one line to add and I've written it out for you. How difficult is it going to be to change it yourself?
And please add code tags to your posts.
Here is a simple macro to clear the contents in the range of your drop down selections... It bypasses your other code, but does what I believe you are trying to accomplish a lot easier.
Re: Reset All Data Validation Lists
Great thanks. That works very well. Now something additional. Not too much but needed. I uploaded another mini game file. It has 2 more drop down lists that also need to be cleared. They are located at C14:H22 and C25:H30 How do I add these areas to also be cleared?
Mini Game.xlsm
Last edited by cat3rn; 12-23-2013 at 10:12 PM. Reason: attachment
Try this attached file.
Thank you for your understanding in adding the code tags
Last edited by FDibbins; 12-24-2013 at 01:12 AM.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Sorry problem corrected on all posts
Re: Reset All Data Validation Lists
Fixed unless it can be done more simply.
All I did was copy paste and change the range areas.
Please Login or Register to view this content.
You can actually just use this:
Please Login or Register to view this content.
You don't need to select anything.
Please Login or Register to view this content.
Regards, TMS
I do much appreciate all of the help and since it is now working wonderfully I consider this SOLVED. Thanks again for the help.
Ok now for the last step. How do I thank those who assisted me in this endeavor?
I used the "Add Reputation" and put in some comments. Is there any other way to thank these people?
http://www.excelforum.com/the-water-...-the-help.html
You're welcome. Thanks for the rep.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks