Results 1 to 8 of 8

debug modes learning

Threaded View

grkchakri debug modes learning 11-17-2013, 01:16 AM
WasWodge Re: debug modes learning 11-17-2013, 04:07 AM
TMS Re: debug modes learning 11-17-2013, 04:17 AM
WasWodge Re: debug modes learning 11-17-2013, 04:23 AM
TMS Re: debug modes learning 11-17-2013, 04:33 AM
grkchakri Re: debug modes learning 11-18-2013, 12:09 AM
WasWodge Re: debug modes learning 11-18-2013, 02:10 AM
Izandol Re: debug modes learning 11-18-2013, 04:51 AM
  1. #1
    Forum Contributor
    Join Date
    02-12-2011
    Location
    Hyderabad
    MS-Off Ver
    Excel 2016
    Posts
    270

    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
    Last edited by grkchakri; 11-17-2013 at 01:19 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Learning VBA - Suggestion for Beginners Learning Curve
    By sighlent1 in forum Excel General
    Replies: 1
    Last Post: 08-26-2010, 12:58 PM
  2. Excel 2007 : Excel 2007 Save Modes
    By ravichander in forum Excel General
    Replies: 4
    Last Post: 07-11-2008, 01:21 PM
  3. [SOLVED] switching between modes
    By Joe in forum Excel General
    Replies: 3
    Last Post: 02-09-2006, 10:00 AM
  4. switching between modes
    By Joe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-08-2006, 12:00 PM
  5. [SOLVED] Design/run modes for a button
    By Mike Reedich in forum Excel General
    Replies: 1
    Last Post: 04-02-2005, 11:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1