Results 1 to 3 of 3

For Next Loop incrementing question

Threaded View

  1. #1
    Registered User
    Join Date
    01-23-2009
    Location
    Newark, DE
    MS-Off Ver
    Excel 2002
    Posts
    30

    For Next Loop incrementing question

    Ok...simple For-Next Loop:

    For i = 1 To 20
        
             If FirstFighterLocation = i Then
                textBox = FirstFighter
            End If
            
        Next i
    However, I have 20 text boxes on the form.

    textbox1
    textbox2
    textbox3
    .
    .
    .
    .
    .
    textbox20


    Depending on which number location is found (i)...I would like "FirstFighter" to be put in the text box named textbox(i).

    Drawing a blank on this one. Is is possible to do this?

    Thanks
    Last edited by panthers7171; 02-24-2009 at 11:45 PM.

Thread Information

Users Browsing this Thread

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

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