Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking userform to userform in Excel 2003 | Excel Programming | |||
[UserForm]: *.gif | Excel Programming | |||
Userform | Excel Programming | |||
Userform inside another userform | Excel Programming | |||
userform | Excel Programming |