intersection with multiple ranges
I am need of some help. I got the script to use an intersection to call a
macro for certain conditions. I have multiple pull downs, 1 being at e12.
based on the pull down selection (o29) then a macro is called. My form has
18 pull downs. if a particular item is selected in the pull down then the
macro executes.
Set t = Target
Set a = Range("e12")
Set aa = Range("o29")
If Intersect(t, a) Is Nothing Then Exit Sub
Cancel = True
If aa.Value = 3 Then idc4_pick
I need to match or intersect e12/029, f12/p29, etc.
Is this a possibility or is it wishful thinking?
thank you in advance for any input.
|