VBA to move the “flashing line cursor”

[Pinaceous]

Hi All,


Is there a way through VBA to move the “flashing line cursor” of which blinks inside a cell?

For example, if the flashing line cursor remains idle inside a cell for example over a minute?

This case is popping up when the user starts to type an entry inside a cell then leaves the cell with the flashing line cursor idle/inactive inside of that cell.

Is there a way to then move the flashing line cursor to another cell or to allow the cell to accept whatever entry is typed if idle for over a minute?

Please let me know.


Thank you,
Pinaceous

 

[Jaafar Tribak]

Do you just want to exit edit mode after a minute ?

Is there a way to then move the flashing line cursor to another cell or to allow the cell to accept whatever entry is typed if idle for over a minute?

I am not sure I have understood the above question

And why do you need this ?

 

[Michael M]

I would have thought simple user education would fix this !!
Otherwise you will need to use SendKeys
ORHave a look at this thread regarding shutting Excel down when idle for a set amount of time.
There is a downloadable workbook with all the required code

https://www.excelforum.com/excel-pr...macro-if-system-is-idle-for-certain-time.html

 

[Pinaceous]

Hi Jaafar Tribak,

I'm sorry for the delayed response, something of an urgent manner came up for me that I had to attend to.

Basically what is happening is that the user has activated a cell and doesn't type anything when activated in producing a mandatory pop-up produced by excel.

Normally, I would not mind this pop-up but it has become somewhat of an issue with the users.

Although the response from post #3 is not what I’m after, I would like an excel pop-up killer for this application.

Can you help me?

Thank you,
Paul