View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ben Ben is offline
external usenet poster
 
Posts: 509
Default update label or text box

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.