Reset Dropdowns with a Button

**aphextwig** · 03-29-2022, 05:34 AM

Hi,
I have a report that uses several dropdowns (data validation lists). It would be great to be able to reset their values to "All" using a button. I assume this requires VBA but I'm no good with it and don't know where to start. Any help greatly appreciated.
Thanks

**CheeseSandwich** · 03-29-2022, 05:59 AM

As long as 'All' is an option in the validation list then:

Please Login or Register  to view this content.

**aphextwig** · 03-29-2022, 06:23 AM

Amazing, this worked perfectly!!! Thanks so much!

Reset Dropdowns with a Button

LinkBack

Thread Tools

Rate This Thread

Display

Reset Dropdowns with a Button

Re: Reset Dropdowns with a Button

Re: Reset Dropdowns with a Button

Thread Information

Users Browsing this Thread

Similar Threads

Create running stopwatch/timer with 1 button (start/stop). No reset button.

[SOLVED] trying to make a disappearing button that reappears by clicking another reset button

Reset Button to reset values to default in Drop List (created in Form Control)

Need data val. dependent dropdowns that recalculate/reset when initial dropdown changes.

[SOLVED] Dynamic (Cascading) Dropdowns that reset on change

[SOLVED] I need to create a reset button that will reset rows containing a specific value

Pivot table, reset dropdowns to all

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions