VBA freezes

[numcrun]

When I update and exit from a cell, certain VBA code runs. Occasionally however, when I exit the cell the hourglass stays on the screen and the code appears to be looping infinitely. So I press Esc and a dialog box comes up asking if I want to continue or stop the code. The debug button is greyed out. So I stopped the code, and retried, stepping through it manually. It then works. Sigh. After these events, the text in the excel input box at the top of the screen (next to the =) flickers rapidly and continuously. This appears to be some flaw in Excel/VBA, I just wonder if it is, and is there a workaround? The KB has nothing I could see.

 

[xlbo]

Can you post the code ??
Sounds like some kinda event driven loop - like using the change event to enter data without turning events off in code

Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde