Reset dependent dropdown to "Please select" on change

J

juliecooper255

New Member
Joined
Apr 24, 2024
Messages
15
Office Version
  1. 365
Platform
  1. Windows
Hi!
I followed the instraction in the thread below but unsuccessfully. I suspect it could be because my drop down are linear rather than column.
www.mrexcel.com

Reset Cell Values Based on Change to Various Cells

Good evening. I have a challenging problem I was hoping to get help with. I have reviewed other posts and found a solution that allows for clearing a range of cells based on a change, but can't find a way to clear different ranges based on different cells changing. I have dependent drop-downs...
www.mrexcel.com www.mrexcel.com

Here is what I am trying to achieve:

Dropdown list in column D (all lines from D16) - When changed, reset all dropdowns in columns E,F,G,H to "Please Select"
Dropdown list in column E (all lines from E16) - When changed, reset all dropdowns in columns F,G,H to "Please Select"
Dropdown list in column F (all lines from F16)- When changed, reset all dropdowns in columns G,H to "Please Select"
Dropdown list in column G (all lines from G16)- When changed, reset all dropdowns in columns H to "Please Select"
 

Attachments

  • Screenshot 2024-04-15 124430.png
    Screenshot 2024-04-15 124430.png
    23.5 KB · Views: 5
Sort by date Sort by votes
Add the MsgBox line to check that the code is being triggered.
VBA Code: 
Private Sub Worksheet_Change(ByVal Target As Range)
Dim r As Long
MsgBox "I have been triggered"  '<<<<
    If Target.Cells.Count > 1 Then Exit Sub
 
Upvote 0

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
So I can't run it as doesn't show in the options, am I missing something? It will only appear when the suntax is Sub Worksheet_Change(). Is there another way to run this code?

1714220297069.png
 
Upvote 0
The code, as with all Event codes, needs to be in the Worksheet Code Module to which it is applicable.
Not in a Module.
Double click the appropriate sheet name within the VBA editor project pane and paste the event code there.
It will then auto-run when its trigger event occurs.
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question
Dependent dynamic list with offset/countif formula and name manager
Replies
1
Views
184
juliecooper255
J
J
  • Question
Dropdown dependent dropdown based upon multiple selections.
Replies
0
Views
108
jcschafer209
J
D
  • Solved
Cannot COUNT/SUM Displayed Table Values, Table Filtered Values Out of Order
Replies
3
Views
98
Alex Blakenburg
A
M
  • Question
VBA vs Formulas/Data Validation for Multiple Dependent Dropdown Lists
Replies
3
Views
729
MissDB101
M
D
  • Question
Copy the value of a cell onto another worksheet based on the dropdown selection
Replies
4
Views
214
mumps
mumps

Forum statistics

Threads
1,216,500
Messages
6,131,015
Members
449,615
Latest member
Nic0la

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top