How to go to a cell after exiting another distant cell?
 

Hi everyone, another stumbling block

I am trying to move to a distant cell after leaving a particular cell.

(my worksheet is protected already-with formulas locked)

I did a search on this and the link:

http://www.xldynamic.com/source/xld.xlFAQ0008.html

Doesn't work for me.

Can someone please help me?

Thanks in advance,

Emilio

I managed to make the link work, but it is not what I am looking for.

I need to be able to jump from 1 cell to another one , and I would like to
do it with code.

Can someone show me an example? Please

Thanks again,
Emilio

"Wind54Surfer" wrote:

Hi everyone, another stumbling block

I am trying to move to a distant cell after leaving a particular cell.

(my worksheet is protected already-with formulas locked)

I did a search on this and the link:

http://www.xldynamic.com/source/xld.xlFAQ0008.html

Doesn't work for me.

Can someone please help me?

Thanks in advance,

Emilio

Wind

There are a couple of methods there. Did neither one work and why not?

A third method is by code if you want to use it.

'moves from C2 through E5 at entry
Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Case "$C$2"
Range("C5").Select
Case "$C$5"
Range("E2").Select
Case "$E$2"
Range("E5").Select
End Select
End Sub

Right-click on your sheet tab and "View Code". Copy/paste in there.


Gord Dibben Excel MVP

On Thu, 24 Feb 2005 11:49:05 -0800, Wind54Surfer
wrote:

Hi everyone, another stumbling block

I am trying to move to a distant cell after leaving a particular cell.

(my worksheet is protected already-with formulas locked)

I did a search on this and the link:

http://www.xldynamic.com/source/xld.xlFAQ0008.html

Doesn't work for me.

Can someone please help me?

Thanks in advance,

Emilio

Whoops. You did say the link didn't work. I mistook that for methods didn't
work. Sorry about that.

Anyway, now you have code.

Gord

On Thu, 24 Feb 2005 16:06:33 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

Wind

There are a couple of methods there. Did neither one work and why not?

A third method is by code if you want to use it.

'moves from C2 through E5 at entry
Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Case "$C$2"
Range("C5").Select
Case "$C$5"
Range("E2").Select
Case "$E$2"
Range("E5").Select
End Select
End Sub

Right-click on your sheet tab and "View Code". Copy/paste in there.


Gord Dibben Excel MVP

On Thu, 24 Feb 2005 11:49:05 -0800, Wind54Surfer
wrote:

Hi everyone, another stumbling block

I am trying to move to a distant cell after leaving a particular cell.

(my worksheet is protected already-with formulas locked)

I did a search on this and the link:

http://www.xldynamic.com/source/xld.xlFAQ0008.html

Doesn't work for me.

Can someone please help me?

Thanks in advance,

Emilio

Thanks, but my knowledge of code in Access doesn't help me here, since there
are no events to trigger the code, can't figure out how to make it work.

Can you please expand on how to get the code to work when exiting say cell C2?

Thanks for any help,
Emilio

"Gord Dibben" wrote:

Whoops. You did say the link didn't work. I mistook that for methods didn't
work. Sorry about that.

Anyway, now you have code.

Gord

On Thu, 24 Feb 2005 16:06:33 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

Wind

There are a couple of methods there. Did neither one work and why not?

A third method is by code if you want to use it.

'moves from C2 through E5 at entry
Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Case "$C$2"
Range("C5").Select
Case "$C$5"
Range("E2").Select
Case "$E$2"
Range("E5").Select
End Select
End Sub

Right-click on your sheet tab and "View Code". Copy/paste in there.


Gord Dibben Excel MVP

On Thu, 24 Feb 2005 11:49:05 -0800, Wind54Surfer
wrote:

Hi everyone, another stumbling block

I am trying to move to a distant cell after leaving a particular cell.

(my worksheet is protected already-with formulas locked)

I did a search on this and the link:

http://www.xldynamic.com/source/xld.xlFAQ0008.html

Doesn't work for me.

Can someone please help me?

Thanks in advance,

Emilio

How stupid of me

Worksheet is not the same as Workbook

I get it now

Thanks a lot!

Emilio

"Wind54Surfer" wrote:

Thanks, but my knowledge of code in Access doesn't help me here, since there
are no events to trigger the code, can't figure out how to make it work.

Can you please expand on how to get the code to work when exiting say cell C2?

Thanks for any help,
Emilio

"Gord Dibben" wrote:

Whoops. You did say the link didn't work. I mistook that for methods didn't
work. Sorry about that.

Anyway, now you have code.

Gord

On Thu, 24 Feb 2005 16:06:33 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

Wind

There are a couple of methods there. Did neither one work and why not?

A third method is by code if you want to use it.

'moves from C2 through E5 at entry
Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Case "$C$2"
Range("C5").Select
Case "$C$5"
Range("E2").Select
Case "$E$2"
Range("E5").Select
End Select
End Sub

Right-click on your sheet tab and "View Code". Copy/paste in there.


Gord Dibben Excel MVP

On Thu, 24 Feb 2005 11:49:05 -0800, Wind54Surfer
wrote:

Hi everyone, another stumbling block

I am trying to move to a distant cell after leaving a particular cell.

(my worksheet is protected already-with formulas locked)

I did a search on this and the link:

http://www.xldynamic.com/source/xld.xlFAQ0008.html

Doesn't work for me.

Can someone please help me?

Thanks in advance,

Emilio