+ Reply to Thread
Results 1 to 2 of 2

for loop with textbox and command button

  1. #1
    Registered User
    Join Date
    12-07-2010
    Location
    south africa
    MS-Off Ver
    Excel 2010
    Posts
    29

    for loop with textbox and command button

    what i want to do is run a for loop that was do the following:

    i have a userform, where a user insert the necessary information, then by clicking on a command button, the info should bestored in other textboxes on the same userform.

    example:

    1.user insert info in textboxes : TBnumber and TBdescription.
    2. user then clicks on command button
    3. TBnumber and TBdescription is then stored in TBno1 and TBdescrp1
    4. TBnumber and TBdescription is then cleared
    5. user types in info like in 1.
    6. user clicks on command button
    7. TBnumber and TBdescription is then stored in TBno2 and TBdescrp2
    ect...

    TBno1.... TBno5 and TBdescrp1.... TBdescrp5 is already created on the forum

    i made use of a for loop, with a counter... but am lost!

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: for loop with textbox and command button

    Hi

    maybe post your sheet to see where the problem lies?

+ Reply to Thread

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