I need a private sub for a workbook that will switch back to the entry cell after the selection is made and calculate. Meaning Cell A2 is the cell where data is entered and after pressing enter or tab or clicking out of cell A2, cell A2 should be reselected and a calculate command should be issued. How can this be done?
Last edited by randell.graybill; 05-19-2010 at 11:41 PM.
If you want a calculation to occur when data is entered every time, leave Auto Calculation on....
Anyway, to reselect a cell you just changed and tell the worksheet to calculate, put this in the sheet module:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
If this is just for A2, then
(If it were for all cells, you'd just set MoveAfterEnter to False; and the only reason to calculate is if calculation is set to manual.)Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
Thanks, both work. And the reason that I want it to be told to calculate manually is all other sheets would also change to auto calc if I enabled auto calc. Some spreadsheets I use do alot of calculates and to auto calculate after every change would slow everything way down.
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks