Consulting

Results 1 to 3 of 3

Thread: Solved: Quick question for anyone with VB

  1. #1
    VBAX Tutor TheAntiGates's Avatar
    Joined
    Feb 2005
    Location
    Tejas
    Posts
    263
    Location

    Solved: Quick question for anyone with VB

    I know what this does in VBA. Could someone tell me how many lines it prints in regular Visual Basic? Thanks.[vba]Sub JimmyLoopVar()
    Dim i As Long, K As Long
    K = 6
    For i = 0 To K
    If (i > 3) Then K = 2
    Debug.Print i; ; K
    Next
    End Sub[/vba]
    I just found a cool semi-advanced VBA page - dictionary, queue, etc. http://analystcave.com/excel-vba-dic...ta-structures/

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Here's the output

    0 6
    1 6
    2 6
    3 6
    4 2
    5 2
    6 2
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    VBAX Tutor TheAntiGates's Avatar
    Joined
    Feb 2005
    Location
    Tejas
    Posts
    263
    Location
    Gracias.
    I just found a cool semi-advanced VBA page - dictionary, queue, etc. http://analystcave.com/excel-vba-dic...ta-structures/

Posting Permissions

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