Hi, dear Mahesh parab it's working and i want this query. Again many many thanks. Actually I am making a customize software for myself use. it's your best compliment. I always remember you when i used this event. your friendsajid memon.
Date: Wed, 7 Jul 2010 22:21:16 +0530 Subject: Re: $$Excel-Macros$$ Problem facing attchment From: mahes...@gmail.com To: excel-macros@googlegroups.com Hi Sajid Click on sheet1 tab right click & select view code copy below mention code enter value in c8 & press enter cursor will move to G14 Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$C$8" Then Range("G14").Select End If End Sub On Wed, Jul 7, 2010 at 7:36 PM, SAJID MEMON <sajidwi...@hotmail.com> wrote: Dear aindril plz help me, awaiting your replay. Date: Mon, 5 Jul 2010 12:08:52 +0530 Subject: Re: $$Excel-Macros$$ Problem facing From: aind...@gmail.com To: excel-macros@googlegroups.com Hi Sajid, Would it be possible for you to share a sample sheet Regards, Aindril On Mon, Jul 5, 2010 at 10:23 AM, SAJID MEMON <sajidwi...@hotmail.com> wrote: Hi Dear I want in excel, when i press enter key cursor should go to particular cell example: my cursor is at A1 and after press enter it should go to D15-- what is the code? My second query is that when i enter any data on the form that should store in particular sheet as below cell wise, example: when i typed any name on the form it will store as sheet1 and address of cell is B1 after that next data store below B1 that is B2, B3 so on. plz help me of these two query code to accomplish my project. Awaiting your replay sajid memon Make the world eco-friendly through MSN Green Drag n' drop -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Chin music and high voltage T20 action on MSN Sports Sign up now. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe _________________________________________________________________ The world on four wheels in MSN Autos http://autos.in.msn.com/ -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe