Hi

Is there a way to pause a macro while it is running?
For example:

COL A COL B
1 2
b 4
5 5

My current macro highlights all characters in this case b.
Is there a way to make it stop when it highlights b, and make it continue running when I want? I'm using a Form for this purpose.

Thanks