Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
After Enter in a cell
When you have entered numbers or text in a cell, and pres
enter, the cellpointer move up or down, left or right or nowhere. How can I find out what it does from VBA. What property do I look for? Thank you Lars Kofod |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
After Enter in a cell
If you record a macro it will only give you the address you went to.
If you want to control where it goes in a macro use OFFSET range("a1").offset(1,4).select -- Don Guillett SalesAid Software "Lars Kofod" wrote in message ... When you have entered numbers or text in a cell, and pres enter, the cellpointer move up or down, left or right or nowhere. How can I find out what it does from VBA. What property do I look for? Thank you Lars Kofod |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
After Enter in a cell
Hi Lars,
The MoveAfterReturn and MoveAfterReturnDirection properties (of the Application object) will give you what you're looking for: Public Function gsMoveAfterReturn() As String If Application.MoveAfterReturn Then Select Case Application.MoveAfterReturnDirection Case xlDown gsMoveAfterReturn = "Down" Case xlUp gsMoveAfterReturn = "Up" Case xlToLeft gsMoveAfterReturn = "Left" Case xlToRight gsMoveAfterReturn = "Right" End Select End If End Function -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] Lars Kofod wrote: When you have entered numbers or text in a cell, and pres enter, the cellpointer move up or down, left or right or nowhere. How can I find out what it does from VBA. What property do I look for? Thank you Lars Kofod |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup if #N/A then enter enter data in cell I4 | Excel Discussion (Misc queries) | |||
Enter multiple numbers in a cell so total shows when enter keypres | Excel Worksheet Functions | |||
Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
How to point to (select) a cell to the left from a cell where I enter the = equal sign? | Excel Discussion (Misc queries) | |||
how do I enter a RETURN (Enter) in a cell in EXCEL2003 | Excel Discussion (Misc queries) |