LinkBack URL
About LinkBacks
when i type abc in A1, the cursor will automatically jump to G1 or in any other cell as i wish
when i type abc in A1, the cursor will automatically jump to G1 or in any other cell as i wish
F5 and type the cell in.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Originally Posted by oeldere
thanks for the reply but what i mean is how to put a formula for that cell (a1) and after pressing enter it would jump to any cell as assigned in the formula. tia
Last edited by excelrio; 08-07-2016 at 06:49 PM.
Hi and welcome to the forum.
What do you mean by 'any cell assigned in the formula'. You really need to tell us what formula you will be entering and which cell (if the formula mentions more than one cell or perhaps a range) the cursor should jump to.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
how can i put or what formula im going to use in cell A1 or any cell after putting characters (abc etc.) that the cursor will jump to a certain cell (c2,c3 etc). thanks
You need to use VBA for that. Using formula this is impossible.
Just to get more clarity here...you want a formula (or something) in A1, and then you want to type something else in A1, and have the cursor go to another, predefined location?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
You need to use VBA for that. Using formula this is impossible.
thanks really...just a newbie in excel
where can i find that vba? and how to use that
I suppose you will need to use VBA to archieve this.
Example:
In Worksheet1, cell A5, after typing something and hit enter or hit any arrow key, you want to go to Cell G5 in Worksheet1, you need to do like this:
Open VBA editor by pressing combo key Alt+F11 (i suppose you have already known this).
One the left handside, double click the Sheet1, on the right handside, you paste this code:
p/s: You will need to change the red and bold part above to suit your need.
Please Login or Register to view this content.
Last edited by gaixixon; 08-07-2016 at 09:41 PM. Reason: attachment
I suppose you will need to use VBA to archieve this.
Example:
In Worksheet1, cell A5, after typing something and hit enter or hit any arrow key, you want to go to Cell G5 in Worksheet1, you need to do like this:
Open VBA editor by pressing combo key Alt+F11 (i suppose you have already known this).
One the left handside, double click the Sheet1, on the right handside, you paste this code:
p/s: You will need to change the red and bold part above to suit your need.Please Login or Register to view this content.
it really help a lot guys thanks much. using it for now and ask again later for help...
No worries.. Helping others is to help myself to memorize things that I hardly use. Why don't you hit "Add Reputation" button instead of saying "thank you"hehe.. Just 4 fun.. "Salamat"
Last edited by gaixixon; 08-07-2016 at 10:21 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks