List with Input Box
 

Something like Data|form?

If that's close, but not quite, then check out John Walkenbach's enhanced
data|form. You can find it at:
http://j-walk.com/ss/dataform/index.htm

and John's comparisons between his version and excel's at:
http://j-walk.com/ss/dataform/features.htm

Ligaya wrote:

What is the best way to program a userrform with a list (from either the
worksheet oor previous list box) for user to input value for each item in
the list?

I have a column with names in a spreadsheet I want to upload on a userform.
The user has to input value for each item and then each input will be dumped
back in the worksheet for each item.

Tried to reload the list with nosuccess.

Thanks.

Ligaya

--

Dave Peterson

List with Input Box
 

"Dave Peterson" wrote:

Something like Data|form?

If that's close, but not quite, then check out John Walkenbach's enhanced
data|form. You can find it at:
http://j-walk.com/ss/dataform/index.htm

and John's comparisons between his version and excel's at:
http://j-walk.com/ss/dataform/features.htm

Ligaya wrote:

What is the best way to program a userrform with a list (from either the
worksheet oor previous list box) for user to input value for each item in
the list?

I have a column with names in a spreadsheet I want to upload on a userform.
The user has to input value for each item and then each input will be dumped
back in the worksheet for each item.

Tried to reload the list with nosuccess.

Thanks.

Ligaya

--

Dave Peterson



Thanks.
Do I have to install the data form add in in evry PC I use the Dataform?
I was hoping that I could design one myself so I have more control over the
form.

Ligaya

List with Input Box
 

"Ligaya" wrote:



"Dave Peterson" wrote:

Something like Data|form?

If that's close, but not quite, then check out John Walkenbach's enhanced
data|form. You can find it at:
http://j-walk.com/ss/dataform/index.htm

and John's comparisons between his version and excel's at:
http://j-walk.com/ss/dataform/features.htm

Ligaya wrote:

What is the best way to program a userrform with a list (from either the
worksheet oor previous list box) for user to input value for each item in
the list?

I have a column with names in a spreadsheet I want to upload on a userform.
The user has to input value for each item and then each input will be dumped
back in the worksheet for each item.

Tried to reload the list with nosuccess.

Thanks.

Ligaya

--

Dave Peterson



Thanks.
Do I have to install the data form add in in evry PC I use the Dataform?
I was hoping that I could design one myself so I have more control over the
form.

Ligaya


I downloaded the Dataform and tried it. I do not think this is the way I
am going.
I just need 2 columns on the form . One for the list of names from the
worksheet and one for the user to put data corresponding to the names and
then export the input to the worksheet.

Thanks.

Ligaya