Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / February 2005

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Wind54Surfer - 24 Feb 2005 19:49 GMT
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
Wind54Surfer - 24 Feb 2005 23:49 GMT
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

> Hi everyone, another stumbling block
>
[quoted text clipped - 13 lines]
>
> Emilio
Gord Dibben - 25 Feb 2005 00:06 GMT
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

>Hi everyone, another stumbling block
>
[quoted text clipped - 13 lines]
>
>Emilio
Gord Dibben - 25 Feb 2005 01:47 GMT
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

>Wind
>
[quoted text clipped - 35 lines]
>>
>>Emilio
Wind54Surfer - 25 Feb 2005 03:33 GMT
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

> Whoops.  You did say the link didn't work.  I mistook that for methods didn't
> work.  Sorry about that.
[quoted text clipped - 42 lines]
> >>
> >>Emilio
Wind54Surfer - 26 Feb 2005 17:19 GMT
How stupid of me

Worksheet is not the same as Workbook

I get it now

Thanks a lot!

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.
[quoted text clipped - 50 lines]
> > >>
> > >>Emilio
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.