RE: $$Excel-Macros$$ Problem facing attchment

2010-07-10 Thread SAJID MEMON

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

Re: $$Excel-Macros$$ Problem facing

2010-07-05 Thread Aindril De
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' 
 drophttp://green.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


-- 
--
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