Greetings:
I'm sure there must be a way to format my worksheet so that when I enter a single number (0-9) into selected cells my cursor would advance automatically to the next unprotected cell to the right without having to use the tab or arrow keys. Can anyone please help?
In the Sheet module:
In a code module:
Please Login or Register to view this content.
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
Thanks Shg, but I can't get it to work
That's not very self-helpful. Exactly what did you do to install and test it?
This is what I would like to occur on one worksheet:
Starting in cell E4 I would like to enter a number (0-9) and I would like to automatically advance to E5 without using tab or arrows. Continuing to cell M4 I would then like to advance to O4 (since N4 contains a sum formula, and is protected). I would then like the same functions in cell O4:W4. I think I would be able to then adapt the formula to the same cells in row 5, 6, & 7. I am sorry but I am relatively new to this and hope that I explained it okay.
I'm sorry I meant advance to F4 (not E5) in the first sentence.
OK. So right now the code is set for single-digit entry in columns C through I. Did you get that to work? And again, what did you do to install the code?
I right clicked on the sheet tab, view code, and pasted the sheet module. Then I tried highlighting the cells and doing the same thing with the code module. Probably wrong I guess.
I continue to get errors. A more specific installation method would be helpful.
See attached. The sheet is protected (as it need be for the behavior you want) with no password. Formula cells must be locked, data entry cells unlocked.
Change this line
to change the range of cells in which the single-digit entry is performed.Please Login or Register to view this content.
Here is the worksheet I am using. I would like to enter the numbers in the gray areas with the cursor advancing automatically to each next cell.
Did you try what I posted?
See attached.
Thanks for trying to help me out. I had to rush to work earlier, sorry. I see the code in the form you sent back to me, but it still doesn't do the trick. It will not advance after I enter the number. Interesting enough, when I go to delete each number it will automatically advance to the next cell so I do not have to use the tab or arrow keys to move. This is the same function I want it to do when I enter data.
shg, I am trying to do the same thing as thedunna. I downloaded scratch.xlsm and tried using your spreadsheet but the cell advance feature doesn't work. I am not getting an error. I will tell you that I downloaded it multiple times and one time it worked but I cannot get it to repeat.
Administrative Note:Originally Posted by Birdman716
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks