vba code has been halted code example

Example 1: vba code has been halted

'In Excel go into the VBA Editor and on the keyboard:

1.) Press and HOLD DOWN the "Ctrl" button
2.) Press "Pause/Break", TWO TIMES.
3.) Let go
4.) Press "F5"

'--------------------------------------------------------------------
'Occasionally during debugging, Excel gets confused and will
'constantly halt execution of one... or even all VBA programs.

'The above procedure corrects the problem.

Example 2: vba code has been halted

'In Excel go into the VBA Editor and on the keyboard:

1.) Press and HOLD DOWN the "Ctrl" button
2.) Press "Pause/Break", TWO TIMES.
3.) Let go
4.) Press "F5"

'--------------------------------------------------------------------
'Occasionally during debugging, Excel gets confused and will
'constantly halt execution of one... or even all VBA programs.

'The above procedure corrects the problem.

Tags:

Misc Example