Modify Calculation
When a user enters data into a cell, he has to tab out of
it before he can push the "calculate" button. Is there any way to change this so that the calculation can be performed while the cell is still selected? I appreciate any help. |
Modify Calculation
Hi Heiko,
Thanks for your efforts to help me. I am very new to Excel and Visual Basic. Could you elaborate on your advice? I don't understand the specifics. Again Thanks, Sisilla -----Original Message----- Hello define a Shortcut for this operation. :-) "Sisilla" wrote: When a user enters data into a cell, he has to tab out of it before he can push the "calculate" button. Is there any way to change this so that the calculation can be performed while the cell is still selected? I appreciate any help. . |
Modify Calculation
Sisilla,
As far as I know, you can't do anything until you finish entering something into a cell. That cell has focus and everything basically stops until you tab out of the cell or press the enter key. John Sisilla wrote: Hi Heiko, Thanks for your efforts to help me. I am very new to Excel and Visual Basic. Could you elaborate on your advice? I don't understand the specifics. Again Thanks, Sisilla -----Original Message----- Hello define a Shortcut for this operation. :-) "Sisilla" wrote: When a user enters data into a cell, he has to tab out of it before he can push the "calculate" button. Is there any way to change this so that the calculation can be performed while the cell is still selected? I appreciate any help. . |
Modify Calculation
Perhaps what you actually want is to avoid the selected
cell moving after pressing Enter (or TAB). If so, deselect the 'Move selection after Enter' checkbox on the Edit Tab of the Tools,Options menu. HTH Graham -----Original Message----- Hi Heiko, Thanks for your efforts to help me. I am very new to Excel and Visual Basic. Could you elaborate on your advice? I don't understand the specifics. Again Thanks, Sisilla -----Original Message----- Hello define a Shortcut for this operation. :-) "Sisilla" wrote: When a user enters data into a cell, he has to tab out of it before he can push the "calculate" button. Is there any way to change this so that the calculation can be performed while the cell is still selected? I appreciate any help. . . |
All times are GMT +1. The time now is 10:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com