+ Reply to Thread
Results 1 to 5 of 5

Loop to generate TextBox

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    01-09-2012
    Location
    Rochester Hills, United States
    MS-Off Ver
    Excel 2010
    Posts
    161

    Exclamation Loop to generate TextBox

    What I have is a frame which has a few text boxes within and a scroll bar. This is used to save space on my form. The problem is coming down to coding. What I could do is create 20-30 instances of these text boxes and when a previous box.value is not blank, the next box in line would be .visible = true. As you can see, after 20 of these, this will simply be a very tedious task - to assign a variable to all of the boxes and then individually create a small code to make each box thereafter visible.

    I was hoping there would be some way to craft a code which would generate a new box based on the scenario when a previous box has been typed in. One of the larger issues I'm not sure how it could work is where the box is generated (I want it to be the same distance below the previous boxes before it).

    Thanks for any tips.
    Regards.

    \1
    HACSGuns.PNG
    Last edited by Phoenix5794; 07-11-2012 at 09:26 AM.

  2. #2
    Forum Contributor
    Join Date
    01-09-2012
    Location
    Rochester Hills, United States
    MS-Off Ver
    Excel 2010
    Posts
    161

    Re: Loop to generate TextBox

    (should maybe create a new thread, but no one has replied to this question yet) Does anyone know why my image isn't showing up here? I read on another tab (and demonstrated it myself) that you simply have to put [IMG] [/IMG] around your URL. Here is the post that it worked for me on, but nowhere else.

    Thanks.

  3. #3
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Loop to generate TextBox

    if I were you I'd use two textboxes and a listbox with a button to add the contents of the textboxes to the listbox, then clear the textboxes ready for the next entry.
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  4. #4
    Forum Contributor
    Join Date
    01-09-2012
    Location
    Rochester Hills, United States
    MS-Off Ver
    Excel 2010
    Posts
    161

    Re: Loop to generate TextBox

    Hmm.. That's not a bad idea. It doesn't seem as cool as the other method, but way easier for sure.
    Thanks JP.

  5. #5
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Loop to generate TextBox

    simple beats cool 99 times out of 100. the other one time it's a tie. :-)

+ 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