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.