I would love to be able to write a formula that instructs the cursor, after data entered in one cell: say i9, move right in a tab fashion to j9, instead on a downward action to i10. Can that be done?
I would love to be able to write a formula that instructs the cursor, after data entered in one cell: say i9, move right in a tab fashion to j9, instead on a downward action to i10. Can that be done?
Last edited by gmaz2; 02-11-2009 at 01:15 AM.
You can set this in Options -> "After Pressing Enter, move Selection": default is down but can be set to Right.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
This applies to the entire spread sheet? How can you designate certain columns/row within a worksheet? For instance like the entire column of I moves the cursor to J only. I can always take your suggestion, and enact the move right when needed?
Last edited by gmaz2; 02-06-2009 at 11:09 PM.
you need to use a macro
The following macro moves selects cell in column K whenever a single cell in column J is changed
'These instructions pre typed & are worded to cater for the novice programmer
'To install macro to correct location
'Copy this macro
'GoTo Excel
'Select sheet this is to appy to
'Right Click on Sheet Name Tab > select View Code
'Paste macro into the Worksheet Module displayed
Please Login or Register to view this content.
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assisted or failed to assist you I welcome your Feedback.
Thank you for this, I copied this as you suggested on a blank excel sheet to test it, worked perfectly-then I tried to add this macro to the worksheet I intended to use this Macro on, received this error
Amiguous_Name change detected. By adding this Macro, it deactivated another Macro I have written to this spread sheet. It has the same name configuration as the Macro you provided-
I believe the Macro has to have a different name set?? The spread sheet has mutiple worksheet names-they are Feb wk1, Feb wk2, Feb wk3, Feb wk4 . . .What must I change so the two macros can coexist?
see attachment in a print screen copied into word so you can see the VB code that way-sorry didn't know I was doing something wrong.
Last edited by gmaz2; 02-07-2009 at 03:11 AM.
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
Please follow following steps
1. Click Tools>Options from the toolbar
2.Select Edit tab from the options dialog box
3.Put a check mark on Move selection after enter
4.From the adjacent drop down list select Direction : Right
Now you get it
Have a nice time
Chris
Last edited by VBA Noob; 02-15-2009 at 06:33 AM.
Chris,
Please read the thread in full prior to posting... your suggestion has already been discussed (in the very first response) moreover the OP has stipulated certain criteria which necessitates VBA as outlined by Mudraker.
gmaz2
You can only have 1 macro of the same name in each module
The picture youenclosed shows you have 2 Worksheet_Change macros in the same module. This is the reason for the Amiguous_Name change detected message
The code from the 2 macros will need to be merged into the 1 macro.
Please post a copy of your 1st Worksheet_Change macro code - not a picture of it.
Thank you Mr. Mudraker for your patience with this.
Attached is the code cut and pasted into a word document
Gmaz2
gmaz2
Sorry for the delay in replyiing.
Whilst I was submitting a reply yesterday I had a system crash & have only just realized me reply did not get posted
I have merged the 2 macro codes into this 1 macro
Please Login or Register to view this content.
P.S
When posting code you will find it quicker & easier for everyone if you post the code within you message.
To post your code so that it is wrapped click on the # icon in the text formating window.
this will add
[co de][/co de] - without the space in the word code
to your message with the cursor inbetween the ][ brackets, paste your code where the cursor is.
When you submit your message the code will show up as wrapped in a window like my code is above
Yes Sir, will do next time I post a request using code. I've learned how to do so, now that I've lived thru this first experience. Thanks for the fix, it works. I have protected this sheet, not wanting any access to the wrong columns, why doesn't the time stamp write to the locked cell? It appears VBA is effected by protecting cells?
I am sorry to hear about your PC-sounds like you're up and running once again. I had thought, maybe you just took Sunday off. After receiving your reply to my question, I will close out this thread.
Again thanks so much.
Gmaz2
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks