Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA for intersection of two named ranges | Excel Programming | |||
intersection of named ranges | Excel Programming | |||
I NEED A FUNCTION TO FIND IF THERE IS AN INTERSECTION BETWEEN 2 DATE RANGES | Excel Worksheet Functions | |||
I NEED A FUNCTION TO FIND IF THERE IS AN INTERSECTION BETWEEN 2 DATE RANGES | Excel Programming | |||
Use intersection of column and TWO ranges in formula? | Excel Programming |