I am working on an order type form and have 4 different data validation
sets. I want to clear the contents of the dependent list when I select the
primary list.
example set. a18 is dependent on what is selected on a17, a20 is dependent
on what is selected on a19
i basically have 4 sets
primary secondary
a17 a18
a19 a20
a21 a22
a23 a24
what i want to do is have it so if I select a new item in the primary
(a17,a19,a21,a23) the secondary is cleared. each data set is a pair. is
there also a way to select a blank and clear both list boxes without
pressing delete.
I tried this code but it only worked for the one pair. I tried copying the
code and adding the other cells but that did not work.
If Intersect(Target, Range("A17")) Is Nothing Then Exit Sub
If Target.Count > 1 Then Exit Sub
Range("A18").ClearContents
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
