BeforeDoubleClick Multiple Rows/Ranges

[ckk403]

I have a code (below) that I am trying to get to work and I quite obviously am out of my element and don't know what I am doing. What I need the code to do is the following:

E3:AH3, E5:AH6, E8:AH12, E14:21 cycle through û and ü.
E4:AH4, E7:AH7, E13:AH13 cycle through û, ü, and N.

The code below isn't working and was me trying to mess around with the first couple rows. Any assistance would help. I feel like it is something simple but I really don't know what I am doing.

Please Login or Register  to view this content.

[smuzoen]

As an example to cycle between û and ü in range E3:AH6

Please Login or Register  to view this content.

[ckk403]

I appreciate the response. I have a script that will accomplish cycling through û and ü in one range E3:AH6. But on Rows 4, 7, and 13 I need N to be an option. I believe I was told previously I couldn't have multiple Private Sub Worksheet_BeforeDoubleClick with difference ranges like: E3:AH3, E4:AH4, E5:AH6, E7:AH7, E8:AH12, E13:AH13, and E14:21. Since I can't use the same script over and over again (unless I can some how). I need to be able to within 1 range have all cycle between û and ü except rows 4, 7, and 13 which cycle through û, ü, and N. Is there anyway to make this happen?

[smuzoen]

Your correct that you cannot have multiple events of the same type (BeforeDoubleClick) in the same sheet however from what I can see the following will should do what you require

Please Login or Register  to view this content.

[smuzoen]

Your correct that you cannot have multiple events of the same type (BeforeDoubleClick) in the same sheet however from what I can see the following will should do what you require

Please Login or Register  to view this content.

[ckk403]

This works fantastically! Thank you very much!