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
