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

[marlonsaveri]

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.

 

[Norie]

Why not use a listbox?

Then you won't be restricted to how many items you can display.

 

[marlonsaveri]

\o/
Thanks so much... So simple thing and it'll solve my problem, thanks a lot.

There is a way to see a listbox like we see a combobox? Or using a combobox like a listbox?

Thanks again.

 

[Norie]

Not sure what you mean.

Both a listbox and a combobox can be populated with multiple items, but if you want to display multiple items use a listbox.

 

[marlonsaveri]

Yes, I need a listbox. I've just tried ask if a listbox would be better with a combobox appearance