+ Reply to Thread
Results 1 to 4 of 4

How to generate labels and textbox on a form from a list in a sheet?

Hybrid View

  1. #1
    Registered User
    Join Date
    01-27-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2007
    Posts
    75

    How to generate labels and textbox on a form from a list in a sheet?

    Hello,
    In my workbook, each worksheet refers to a name (sample: city) and within the sheets, there are properties on this name. As a database in Excel, easily understood by users).
    I created a form where you can insert new sheets with new properties using "labels" and "textbox" fixed. (A new worksheet is created with the chosen name and some properties are typed in textbox pasted in the new sheet).
    However, they asked me to do more than that: I have a form that is able to insert new names (sheets); i need one that is able to insert new properties, ie: when the user enters a new property, a new line appears in each sheet dealing with such property.
    Problem: When I want to insert a new account, this new property isn't be there in form, because the labels and textbox are fixed. So, I need a form textbox and labels that vary according to who is on a list (without knowing how many words are on the list) and, finally, pressing enter, your entry will appear in the new worksheet Textb ahead the names of the properties.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: How to generate labels and textbox on a form from a list in a sheet?

    Hello marlonsaveri,

    To better illustrate your problem, you should post your workbook. It will make clear what you are referring to in your post. You should also include before and after examples of the data and the intended results you expect. If your workbook contains sensitive or confidential information, please be sure to change the names of people and businesses before posting it.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    01-27-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2007
    Posts
    75

    Re: How to generate labels and textbox on a form from a list in a sheet?

    Thanks Ross.
    However, a listbox solved my problem.
    I didn't know listboxes, so I was finding how to print many and unknown words in labels... So, a listbox solved it.

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: How to generate labels and textbox on a form from a list in a sheet?

    Hello marlonsaveri,

    I am glad you found an answer to you r problem. Just disappointed I did not get chance to help. Maybe next time.

+ 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