Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can macro return me to cell edit mode
Can a macro after it runs return me to a cell in edit mode?
I made "rong entry of cell" runs a macro deponds on a cell that is calculated (i used calculate event) and i don't want to delete the cell contents but just edit in it instead of writing the whole entry agian If i don't delete the entry in the biginning of macro it runs continously until i break it thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can macro return me to cell edit mode
Please post your code.
-- HTH, Barb Reinhardt "Khaled" wrote: Can a macro after it runs return me to a cell in edit mode? I made "rong entry of cell" runs a macro deponds on a cell that is calculated (i used calculate event) and i don't want to delete the cell contents but just edit in it instead of writing the whole entry agian If i don't delete the entry in the biginning of macro it runs continously until i break it thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can macro return me to cell edit mode
You can put this in before your End Sub statement, but realize you won't be
able to run any code while you're in edit mode. James SendKeys "{F2}" "Khaled" wrote in message ... Can a macro after it runs return me to a cell in edit mode? I made "rong entry of cell" runs a macro deponds on a cell that is calculated (i used calculate event) and i don't want to delete the cell contents but just edit in it instead of writing the whole entry agian If i don't delete the entry in the biginning of macro it runs continously until i break it thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can macro return me to cell edit mode
Thank you very
simple and right answer but great thanks "Zone" wrote: You can put this in before your End Sub statement, but realize you won't be able to run any code while you're in edit mode. James SendKeys "{F2}" "Khaled" wrote in message ... Can a macro after it runs return me to a cell in edit mode? I made "rong entry of cell" runs a macro deponds on a cell that is calculated (i used calculate event) and i don't want to delete the cell contents but just edit in it instead of writing the whole entry agian If i don't delete the entry in the biginning of macro it runs continously until i break it thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I know you can't run a macro while in edit mode, but... | Excel Discussion (Misc queries) | |||
Is it possible to arrow to a different cell while in edit mode? | Excel Discussion (Misc queries) | |||
cell value in edit mode with COM addin | Excel Programming | |||
Detecting Cell Edit Mode | Excel Programming | |||
running macro while in the edit mode | Excel Programming |