In my macro, I display a form where the user enters data.
When they push the "submit" button, the data will be
displayed in a label or a text box on the form they are
using to enter data. This is not a problem.

The user has the ability to enter additional lines. The
problem is I don't know how many lines they will enter.
It may be 1 or 10 or 20. I was thinking about displaying
10 rows of data. The problem occurs if they enter more
than 10. How can I display all of the rows that they
enter?

Can I user scroll bars on a text box or label. I don't
necessarily have to have every row they enter visible but
they should have the ability to review all of the data
they entered.

Is a better way to build a combo box?

Any suggestions or ideas on the way to go would be great.
Thanks for your help.

Sound backwards,

Usually a user enters data in a Userform and when a button is pushed it is
added to cells in a spread sheet.

It is unclear what you are doing. Use of the term "form" is ambiguous.

--
Regards,
Tom Ogilvy

"JT" wrote in message
...
In my macro, I display a form where the user enters data.
When they push the "submit" button, the data will be
displayed in a label or a text box on the form they are
using to enter data. This is not a problem.

The user has the ability to enter additional lines. The
problem is I don't know how many lines they will enter.
It may be 1 or 10 or 20. I was thinking about displaying
10 rows of data. The problem occurs if they enter more
than 10. How can I display all of the rows that they
enter?

Can I user scroll bars on a text box or label. I don't
necessarily have to have every row they enter visible but
they should have the ability to review all of the data
they entered.

Is a better way to build a combo box?

Any suggestions or ideas on the way to go would be great.
Thanks for your help.

try using a list box instead, same basic programming as a "Combo Box" and it
automatically adds scroll bars

"JT" wrote:

In my macro, I display a form where the user enters data.
When they push the "submit" button, the data will be
displayed in a label or a text box on the form they are
using to enter data. This is not a problem.

The user has the ability to enter additional lines. The
problem is I don't know how many lines they will enter.
It may be 1 or 10 or 20. I was thinking about displaying
10 rows of data. The problem occurs if they enter more
than 10. How can I display all of the rows that they
enter?

Can I user scroll bars on a text box or label. I don't
necessarily have to have every row they enter visible but
they should have the ability to review all of the data
they entered.

Is a better way to build a combo box?

Any suggestions or ideas on the way to go would be great.
Thanks for your help.

JT

If your using a userform with a textbox, you can set the properties for the
textbox in question to:
MultiLine = True
ScrollBars to "2"
WordWrap = True

Charles
"JT" wrote in message
...
In my macro, I display a form where the user enters data.
When they push the "submit" button, the data will be
displayed in a label or a text box on the form they are
using to enter data. This is not a problem.

The user has the ability to enter additional lines. The
problem is I don't know how many lines they will enter.
It may be 1 or 10 or 20. I was thinking about displaying
10 rows of data. The problem occurs if they enter more
than 10. How can I display all of the rows that they
enter?

Can I user scroll bars on a text box or label. I don't
necessarily have to have every row they enter visible but
they should have the ability to review all of the data
they entered.

Is a better way to build a combo box?

Any suggestions or ideas on the way to go would be great.
Thanks for your help.