double click and intersection

[pburke11]

I am not having much success. I have part of it working. so far I have:

Set Target = ActiveCell
Set a = Range("e12")
Set b = Range("f12")
Set aa = Range("o29")
Set ab = Range("p29")
If aa = 3 And Intersect(Target, a) Is Nothing Then Exit Sub
Cancel = True
idc4_pick
If ab = 3 And Intersect(Target, b) Is Nothing Then Exit Sub
Cancel = True
idc5_pick

o29,p29 are cell reference for selected pull down list item.
18 possible pull down references.
the e12,f12 cells correlate to the pull down lists.
If the user double clicks e12 macro executes. if f12 is double clicked cell goes into edit mode.
I am missing something. Any ideas?
Any input would be greatly appreciated.

 

[GlennUK]

If f12 is double-clicked ... and what is in Range("o29") when you do that? Could it be that:
If aa = 3 And Intersect(Target, a) Is Nothing Then Exit Sub
... is executing?

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[Bong]

You likely have some problem happening in idc5_pick

_________________
Bob Rashkin