I would like to place a list box using any method, the forms toolbar, the
validation function, etc.. I don't know which to use but I need to have this
at the top of the column and my cursor will traverse down the column. I want
to move the cursor down one row, goto the list box, select the value and have
it automatically populate the cell I was in. then move to the next cell and
repeat the process? Basically moving the value from the list box to the
active "cell"

Try this:
http://www.officearticles.com/excel/...soft_excel.htm

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"jwh" wrote in message
...
I would like to place a list box using any method, the forms toolbar, the
validation function, etc.. I don't know which to use but I need to have
this
at the top of the column and my cursor will traverse down the column. I
want
to move the cursor down one row, goto the list box, select the value and
have
it automatically populate the cell I was in. then move to the next cell
and
repeat the process? Basically moving the value from the list box to the
active "cell"

I did try that solution before and yes it does sort of get me there but it
would be more effective for my needs if I could have the drop down list in
one place, rather than on each row on that cell. But I would be in any cell
and then goto the drop down list and select the value, then it would
automaically fill in the value from that list to my originally active cell.
Similar to what you suggested but only having the selections pictured once
and have the user pick from that list.

"Anne Troy" wrote:

Try this:
http://www.officearticles.com/excel/...soft_excel.htm

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"jwh" wrote in message
...
I would like to place a list box using any method, the forms toolbar, the
validation function, etc.. I don't know which to use but I need to have
this
at the top of the column and my cursor will traverse down the column. I
want
to move the cursor down one row, goto the list box, select the value and
have
it automatically populate the cell I was in. then move to the next cell
and
repeat the process? Basically moving the value from the list box to the
active "cell"

Then you need a listbox (if one column/value) or a combobox (if more than
one), and VBA to help you along... I'll move out of the way for a coder to
help you!
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"jwh" wrote in message
...
I did try that solution before and yes it does sort of get me there but it
would be more effective for my needs if I could have the drop down list in
one place, rather than on each row on that cell. But I would be in any
cell
and then goto the drop down list and select the value, then it would
automaically fill in the value from that list to my originally active
cell.
Similar to what you suggested but only having the selections pictured once
and have the user pick from that list.

"Anne Troy" wrote:

Try this:

http://www.officearticles.com/excel/...soft_excel.htm

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"jwh" wrote in message
...
I would like to place a list box using any method, the forms toolbar,
the
validation function, etc.. I don't know which to use but I need to
have
this
at the top of the column and my cursor will traverse down the column.
I
want
to move the cursor down one row, goto the list box, select the value
and
have
it automatically populate the cell I was in. then move to the next
cell
and
repeat the process? Basically moving the value from the list box to
the
active "cell"