Run Macro Line by Line in Worksheet Module

[Sahak]

Hi All,

How to run a macro one line at a time in Worksheet Module (Not Regular Module)

Thank you in advance

 

[tweedle]

Open the code and go to the first executable line
F9 will put a break there and when the code runs, it will stop and wait for you
Pressing F8 will 'step' through the lines

 

[Sahak]

Thank you veru much for reply.
What you suggesting that is for regular module, I was asking about worksheet module.

 

[Michael M]

I'm not certain that you can in the worksheet module.
However, why don't you copy it to a regular module and test it there, using Tweedles method

 

[Sahak]

Thank you Michael for reply.
I cant do that because Im using worksheet procedure like:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

I must DoubleClick on Worksheet to test it
Or

 Private Sub Worksheet_Change(ByVal Target As Range)

or

 Private Sub Worksheet_SelectionChange(ByVal Target As Range)

 

[meldoc]

Hello

tweedle's method will work.

 

[Sahak]

Sorry, I dont know about tweedle's method, Could you please explain?

 

[meldoc]

See the link.

http://www.cpearson.com/excel/debug.htm

 

[Nalani]

If you have something like this:

Private Sub Worksheet_Change(ByVal Target As Range)
'//Check for duplicate project names on entry
'//and convert project name to uppercase.
    Dim intResponse As Integer
    Dim rng1 As Range, rng2 As Range, cell As Range, rng3 As Range, rng4 As Range
    On Error GoTo errTrap
    Application.EnableEvents = False
    If Not Intersect(Target, Columns(1)) Is Nothing Then
 
''''''more code'''''''
 
End sub

With tweedle suggestion ----- place your cursor on the first executable line, in this case it is On Erro GoTo errTrap, then press your F9 key.

A little spot will appear to the left and that line will turn a dark color. This is a Break Point.

(Ultimately, you could just place your Pointer in that margin to the left and L/Click)

Go back to your worksheet and type something in it and hit Enter. the code will stop on the Break Point waiting for YOU to step through it with F8.

 

[Sahak]

Thank you guys very much.