Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Modify Formula | Excel Worksheet Functions | |||
Modify a UDF please? | Excel Worksheet Functions | |||
Modify a UDF please? | Excel Worksheet Functions | |||
Modify A Macro | Excel Worksheet Functions | |||
Modify width | Setting up and Configuration of Excel |