maybe if I explain my objective, it's easiest to find a solution. I attached pictures.
Basically, the macro is to register creditors in our system (very dated) that use the IBM Terminal). So, he get the data of first collumn (our id) and put inthe terminal (pic1). after it, there are two options:
if thecreditor is already registered, the terminal open the window for change (see in the pic2_ ( A-ALTERACAOE-EXCLUSAO ) ). notice that (pic3) shift + right select the field of the cursor in second screen.

that option is not what I want. only so, I use F12 in the macro to return to first screen (pic1) and get the second line of excel.
if the creditor is not registered ( pic4, notice OPCAO : I - INCLUSAO), so, that macro proceeds to insert otherdata (other columns). but the field in that case is not empty (why? well, because the terminal pull the data from other database)
I thought, ifI test the field after first screen, shift+right, crtl+c, variable (if = 0,it's the screen for change. if <> 0, its the screen for insert), I would find a solution.


but maybe there are another form of test . could I test the position of cursor?? I don'tunderstant much of vba.

pic1.jpgpic2.jpgpic3.jpgpic4.jpg