View original (French)

Exit a cell when entering data

ThomasMexcel Posted messages 28 Registration date   Status Member Last intervention   -  
 yves -
Hello, by pressing F2, it is possible to "enter" a cell to insert text. Then, if you press Escape, you can "exit" the cell without validating the text.
I have an Excel file on which I run several macros. When I am still entering text in a cell, if I change files, an error message appears because the macros can no longer run.
The question is then the following: how can it be possible to "exit" the cell with a VBA command, so I can navigate freely between my different files?
I hope I have been clear enough..
Thank you in advance for your help, have a good day.

1 answer

  1. yves
     
    Hello Thomas,

    Try using this VBA instruction: 

     SendKeys "{ESC}", True

    It's to simulate a press of the ESC key with VBA;
    with True, the macro waits for the key to be processed before
    continuing its execution; check the VBA help for more
    details on the SendKeys instruction.

    Best regards
    1
    1. ThomasMexcel Posted messages 28 Registration date   Status Member Last intervention  
       
      Hello Yves,
      Indeed, the proposed order could be a solution.
      However, I can't determine the equivalent VBA condition for: if I am in input mode in a specific range of cells for more than 1 second, then SendKeys Escape." I suppose I have to allow some time during which I permit input; otherwise, I'll get stuck..
      0
      1. yves > ThomasMexcel Posted messages 28 Registration date   Status Member Last intervention  
         
        According to the VBA help for the SendKeys instruction, the 2nd parameter allows you to wait
        or not for the processing of the sent key sequence (here "{ESC}"), but it does not
        allow for a finer configuration like the one you want: there is no 3rd
        parameter for a delay (one second or otherwise); I don’t have any other solution
        to offer you; perhaps another participant will have an idea?
        0