Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
When does entering data into cell end?
I am writing an application that uses dsoFramer Active X to make Excel Sheets
available. I can use full Excel/VBA functionality. The Problem: When a user edits a cell and does not finish entering (there is still a prompt inside the cell) and pushes any button outside the Excel Frame, I can not make this cell stop edit mode and let it know the entered value. If I jump into another cell like Range("B4").Select() the cursor jumps and the new cell is focused but the old one is still in edit mode and the beeing entered value is not available. Is there any method in Excel VBA that makes the edit mode end up? Something like Range("A2").Enter() or sth like that? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
When does entering data into cell end?
I'll take a wild stab at this, since no one else has answered. Try setting
Application.DataEntryMode to xlOff and then back to xlOn - that might cause it to digest the cell being edited. -- In theory, there is no difference between theory and practice; in practice, there is. "MarkusPoehler" wrote: I am writing an application that uses dsoFramer Active X to make Excel Sheets available. I can use full Excel/VBA functionality. The Problem: When a user edits a cell and does not finish entering (there is still a prompt inside the cell) and pushes any button outside the Excel Frame, I can not make this cell stop edit mode and let it know the entered value. If I jump into another cell like Range("B4").Select() the cursor jumps and the new cell is focused but the old one is still in edit mode and the beeing entered value is not available. Is there any method in Excel VBA that makes the edit mode end up? Something like Range("A2").Enter() or sth like that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill Row after entering data into one cell | Excel Worksheet Functions | |||
Time with entering data in the corresponding cell | Excel Discussion (Misc queries) | |||
Coloring of cell when entering data | New Users to Excel | |||
Entering data in a cell | Excel Discussion (Misc queries) | |||
entering data in certain cell | Links and Linking in Excel |