Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
new in 2003, I am getting a delay when entering data before the cursor jumps
to the next cell. It seems to be related to iteration, but iteration didn't produce this effect in 2000. Anyone know why and how to prevent the delay? |
#2
![]() |
|||
|
|||
![]()
I don't know of a reason iteration would affect this.
But my first though was that you had a worksheet_change event firing that was calling itself recursively until excel gave up trying. If you open the workbook with macros disabled, do you have the same delay? If no, try rightclicking on the worksheet tab and selecting view code. (If the project is protected, you may need a password to see this.) If you see code there, you may have found the problem. If you have trouble fixing it, copy the code into a followup message. (Not the workbook!) I'm sure someone will be able to help. doctor9 wrote: new in 2003, I am getting a delay when entering data before the cursor jumps to the next cell. It seems to be related to iteration, but iteration didn't produce this effect in 2000. Anyone know why and how to prevent the delay? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
entering data in certain cell | Links and Linking in Excel | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) |