debug modes learning

Hi All

I am trying to understand what these debug modes are all about, i Know its very essential in a coding which will help us.
But some one can tel me where and how we should use this. I have a long list of queries out of which few are.

Debug.print
debut.assert
Immediate window. (I know this is something which we use to see immediate results for your coding)

My code is below. which is a very small programme. where it just shows left,right of a string in the cells. MY query is where i can use the above two to options(debut print and debug asser) and understand how it helps. what is that in the immediate window should i type / paste to see the immediate results. have read articles from cpearsons, but while it comes to my coding i am confused.

Private Sub nameincells_Click()

Dim NIC1 As String
Dim NIC2 As String
Dim NIC3 As String
Dim NIC4 As String
Dim NIC5 As String
Dim NIC6 As String


'NIC1 = InputBox("ENTER A STRING")
 NIC1 = "ARTHUR DAVID SIMON"
MsgBox NIC1
 

NIC2 = Len(NIC1)
MsgBox "Length of the string is:-" & NIC2

For I = 1 To NIC2
Sheets("Sheet5").Activate
ActiveSheet.Cells(I, 5).Value = Left(NIC1, NIC2 - (NIC2 - I))          ' To fill one letter each from left and build in the next rows
ActiveSheet.Cells(I, 7).Value = Right(NIC1, NIC2 - (NIC2 - I))          ' To fill one letter each from right and build in the next rows
ActiveSheet.Cells(I, 6).Value = Mid(NIC1, 1, NIC2 - (NIC2 - I))


Next I

End Sub

Perhaps the link below will help

http://www.cpearson.com/excel/DebuggingVBA.aspx

Debug.Print just displays the contents of a variable or a cell.

Debug.Assert can be used to test a variable or cell and cause the code to stop. I must admit to never having used this ... And you certainly wouldn't want to leave it active in your code.

You can see the output from Debug.Print in the Immediate Window. Press Ctrl-G to open the Immediate Window pane if it is not showing in the VBE.


Regards, TMS

Originally Posted by TMShucks

Debug.Assert .... I must admit to never having used this ... And you certainly wouldn't want to leave it active in your code.

Snap!!!!!!!

@WasWodge: yes, and for a long time I didn't even know it was an option. But, even when I discovered it (I think, on Chip's web site), I have never found reason to use it. Other debug methods usually work well for me, like putting a Stop in the code, or adding a break point, and stepping through the code with F8.

Regards, TMS

a) It shows whatever you put after it (normally the result of a variable,a text string, result of a formula (see your adapted code below)).
b) yes
c) Can't think of a use for it but the easiest way would probably be to put in a counter to count the iterations. See x in your adapted code below.

Private Sub nameincells_Click()

    Dim NIC1 As String
    Dim NIC2 As String
    Dim NIC3 As String
    Dim NIC4 As String
    Dim NIC5 As String
    Dim NIC6 As String
    Dim i As Long, x As Long


    'NIC1 = InputBox("ENTER A STRING")
    NIC1 = "ARTHUR DAVID SIMON"
    MsgBox NIC1


    NIC2 = Len(NIC1)
    MsgBox "Length of the string is:-" & NIC2
    x = 0
    For i = 1 To NIC2
        Sheets("Sheet5").Activate
        ActiveSheet.Cells(i, 5).Value = Left(NIC1, NIC2 - (NIC2 - i))          ' To fill one letter each from left and build in the next rows
        ActiveSheet.Cells(i, 7).Value = Right(NIC1, NIC2 - (NIC2 - i))          ' To fill one letter each from right and build in the next rows
        ActiveSheet.Cells(i, 6).Value = Mid(NIC1, 1, NIC2 - (NIC2 - i))
        x = x + 1
        If x > 14 Then Debug.Print i
    Next i
    Debug.Print WorksheetFunction.Sum(1, 3, 4, 5)
End Sub