View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Toggling navigating between 3 cells?

GS used his keyboard to write :
.e., from startpoint (whatever it is) go to D2
from D2 to G2 and then each time pressing navigation goes backwards:
G2 to D2
D2 to A2


In this case, you might want to reset the var...

1st click: set var to next position (1 in this case)
2nd click: check var and set to next position (2a in this case)
3rd click: check var and set to next position (3 in this case)
4th click: check var and set to next position (2b in this case)
5th click: check var and set to next position (1 in this case)

...so that when the var is '2a' you know to activate the 3rd cell in the
sequence next. When it's '2b' you know which dir it's going and so the
cycle repeats.

HTH

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc