Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a problem.
I write to cell, and I want to wait until ALL code that fires off that event to finish before I run my code to read the resulting cells. I tried a DoEvents and that worked in most 99.9% of the cases and has for years. BUT with the last save the timing got messed up and I had to put in a 3-5 second delay in this one sheet (looping until timer OldTimer + 5) Any better way of doing this? (This was my single step problem, not working it 1 of 2 methods of full speed operation and when I single stepped it.) PS. Excel 2000 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Code to conditional format all black after date specified in code? | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
Excel VBA- Time delaying macro | Excel Programming | |||
Delaying calculations | Excel Programming |