Clear dependent list based on a cell value!
I have a data validation list based on the value of a cell. I used the indirect formula, so every the value in this cell is changes the dependent one refers to a new named range (which I can choose from in the drop down list). I want my dependent list to be reset to blank (or better even to a default value "select"), every time the value in the main cell is changed.
I found code that works fine if I have a main and dependent list but since my "main" cell has simply a value and is not a data validation list, the code does not work.
B3 -parent cell (value change controlled by a combo-box (linked cell))
A13-A21 contain data validation list based on the value in B3 (list => indirect($B$3))
Anyone has a solution?
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By Ceekimmy in forum Excel - New Users/Basics
Last Post: 04-30-2019, 04:33 PM
By ALNER in forum Excel Programming / VBA / Macros
Last Post: 08-16-2014, 09:55 AM
By dpleventhal in forum Excel Programming / VBA / Macros
Last Post: 12-01-2013, 04:45 PM
By Capolan in forum Excel Programming / VBA / Macros
Last Post: 06-21-2013, 04:05 AM
By ACap in forum Excel Programming / VBA / Macros
Last Post: 10-29-2012, 10:03 AM
Tags for this Thread
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1