update label or text box

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" <anonymous@discussions.microsoft.com> wrote in message
news:20a201c50899$294da4e0$a501280a@phx.gbl...
> 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" <anonymous@discussions.microsoft.com> wrote in message
news:20a201c50899$294da4e0$a501280a@phx.gbl...
> 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.
>