I want my cursor to move from A1 to C1 after my first entry and then from C1 to A2 and so on. Can anyone tell me how to make this happen? Your help would be greatly appreciated.
Thanks,
Jeff
![]()
I want my cursor to move from A1 to C1 after my first entry and then from C1 to A2 and so on. Can anyone tell me how to make this happen? Your help would be greatly appreciated.
Thanks,
Jeff
![]()
Last edited by KERNELJEFF; 12-29-2011 at 10:38 AM. Reason: Solved
Hi Jeff,
You can use something like:-
Regards,![]()
Selection.Offset(1, 3).Select
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
DILIP,
Not sure how to do that? I tried typing it in the cell but that didn't work?
Thanks,
Jeff
Hi Jeff,
Please upload the sample file.
Click on Go Advanced on the right side of reply section and the look for paper clip on the menu icons.
Regards,
DILIPandey
<click on below 'star' if this helps>
Sorry but I can't find the sample file.........I clicked the star to quick![]()
Hi Jeff,
By sample file, I am referring the file on which you are going to work but please replace the original data with some dummy results for confidentaility purpose. Thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
cursor test.xls Here you go............
This also relates to How to assign a macro to a cell.
Please find attached sheet and see if it works for you?
nlm
--
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little scale)
Thanks nlm! Unfotunatly this worded only in column C on your sheet but that's ok. I'm going to close this thread but would appreciate if you look at the other one I have going regarding "How to Sign a Macro to a Cell.
Thanks again.
It is preferable to have single post for single question!
Now to your question of assigning macro to a cell. You can assign macro to individual cell through code that I sent in attached file. The way you want can only be done through VBA code:
nlm.![]()
Private Sub Worksheet_Change(ByVal Target As Range) enter the cell/range you want to control.... and the macro will be assigned accordingly.
Hi Jeff,
I could'nt look into this as I was litte occupied.
I hope the solution provided by nlm helped you. Thanks to nlm. Cheers
Regards,
DILIPandey
<click on below 'star' if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks