Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
vj5 vj5 is offline
external usenet poster
 
Posts: 22
Default problem in excel

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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default 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.




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,173
Default 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.




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 290
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Colon at the end of excel file name(ex: problem.xls:1, problem.xls financeguy New Users to Excel 2 January 15th 10 01:15 AM
Problem viewing Excel 2003 Pivot Chart fields in Excel 2007 ronny B Charts and Charting in Excel 1 October 24th 08 10:08 PM
Weird problem with Excel 2000...Worksheets disappearing in a shared Excel file BrianL_SF Excel Discussion (Misc queries) 2 October 10th 06 08:27 PM
Started out as an Access problem. Now an Excel problem RobertM Excel Discussion (Misc queries) 2 April 26th 06 07:30 PM
Excel 97 chart opened in Excel 2003 - Source Data problem DHunt Charts and Charting in Excel 0 December 6th 04 08:05 PM


All times are GMT +1. The time now is 09:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"