userform help
 

Hi,

I am trying to create a userform and need some help. The
idea is to have the user enter an account number(s) and a
dollar ammount that will ultimately populate an excel
sheet.

The number of account numbers varies from user to user.
Is there a way to have something like a text box that
expands as more inputs are necessary.

I would like the user to enter the acct num then hit
enter to enter the next and so on.

Thanks

userform help
 

Jason,

One method is to add a list box to the form. Then the user can type in a
text box and you could use a submit button to add it to the list box.
Lastly, add a process button that would loop thru all the list box items and
place the accounts in the address box

"Jason" wrote:

Hi,

I am trying to create a userform and need some help. The
idea is to have the user enter an account number(s) and a
dollar ammount that will ultimately populate an excel
sheet.

The number of account numbers varies from user to user.
Is there a way to have something like a text box that
expands as more inputs are necessary.

I would like the user to enter the acct num then hit
enter to enter the next and so on.

Thanks