macro reset drop down

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Macro to reset drop down list

Macro to reset drop down list

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Shortcut keys to move between sheets

Instead of clicking on a sheet tab to view a sheet, use the following keyboard shortcuts to move between sheets in the same file:

Ctrl + Page Down - Switch to the next worksheet (to the right)

Ctrl + Page Up - Switch to the previous worksheet (to the left)

View all Excel hints and tips


Server loaded in 0.07 secs.