98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Macro to reset drop down list
Macro to reset drop down list
Resolved · High Priority · Version 2003
Angela has attended:
Excel VBA Intro Intermediate course
Macro to reset drop down list
Hi
I would like to create a macro that resets a drop down list to a default value.
For example I have created an spreadsheet with a list of countries in a drop down list and the default value is 'please select a country'. I would like to the user to be able to clear the sheet each time they use it and have the drop down list value reset to 'please select a country'.
I've already created a macro that clears the other inputs on the sheet.
Many thanks
Angela
RE: Macro to reset drop down list
Hi Angela
Thank you for your question
There are several possible approaches to this problem. It is however difficult to advise without seeing the spreadsheet in question as its layout and existing code are important considerations
If you can email me a copy to stephen@stl-training.co.uk, I can then investigate and advise
Regards
Stephen
RE: Macro to reset drop down list
Hi Angela,
Did you manage to get a copy of your workbook over to Stephen?
This question has now been left unattended for a while.
We like to keep down the large number of active forum posts we receive.
As we are waiting for your response for further information to help resolve your issue, we will be automatically marking this question as resolved in the next 5 days (unless you post a follow-up within that time).
We look forward to hearing from you.
Thank you.
Regards, Rich
Wed 20 May 2009: Automatically marked as resolved.
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Shortcut keys to move between sheetsInstead of clicking on a sheet tab to view a sheet, use the following keyboard shortcuts to move between sheets in the same file: |