Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to keep a running tally in a cell while the vba code is still
running. So I say sometheing like... For K = 1 to 100 TopicWS.Cells(1, 2).Value = K '-- do something which takes a second or two Next But the new values of K (1..99) do not become visible in Cell(1, 2) until the program stops, at which point only the last one (100) is showing. How do I get it to update visibly while still running? Thanks. --David. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I make a running total change in a new cell | Excel Worksheet Functions | |||
How to make visible all text in cell with word wrap on | Excel Discussion (Misc queries) | |||
How to make sure a Cell is within the current visible window's ran | Excel Programming | |||
Running a macro by changing a cell value | Excel Programming | |||
How can I make the bar that shows the content of the cell visible. | Excel Discussion (Misc queries) |