problem in excel
 

How to write in excel cell when cell is in edit mode.
i tried with sendkeys but its not working.

problem in excel
 

As we have explained before, basically Excel does not let you do this, apart
from limited success with SendKeys as you as know.
You should rethink your strategy instead of fighting against the
application.

Why do need to do all this ?

NickHK

"vj5" wrote in message
...
How to write in excel cell when cell is in edit mode.
i tried with sendkeys but its not working.

problem in excel
 

Without unreliable sendkeys{} you cannot enter anything via VBA when Excel
is in Edit Mode

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"vj5" wrote in message
...
How to write in excel cell when cell is in edit mode.
i tried with sendkeys but its not working.

problem in excel
 

Agree,

Excel is caught in a polling loop when in edit mode, should really find
another way of achieving your goal.

Duncan


Nick Hodge wrote:

Without unreliable sendkeys{} you cannot enter anything via VBA when Excel
is in Edit Mode

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"vj5" wrote in message
...
How to write in excel cell when cell is in edit mode.
i tried with sendkeys but its not working.