Drop down list or combo box help needed
 

I am hopeful that someone will know how to accomplish this:

In a single column of a worksheet
1. Create a selection list (or choices) which can populate the cells of
that column
2. Create a list box or combo box to hold the choices
3. Have that list or combo box appear when one of the individual cell of
this column becomes active.

I've had several attempts at this, but haven't accomplished this yet. I've
created these in the past in Word, but I know it is more complex than what
I've done in Word. Any help you can provide is greatly appreciated!!!!!!
Sincerely, mary trueblood :-)

Sounds like Data ValidationList may be what you need.

See Debra Dalgleish's site for info and instructions.

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben Excel MVP

On Wed, 12 Jan 2005 11:19:05 -0800, "metrueblood"
wrote:

I am hopeful that someone will know how to accomplish this:

In a single column of a worksheet
1. Create a selection list (or choices) which can populate the cells of
that column
2. Create a list box or combo box to hold the choices
3. Have that list or combo box appear when one of the individual cell of
this column becomes active.

I've had several attempts at this, but haven't accomplished this yet. I've
created these in the past in Word, but I know it is more complex than what
I've done in Word. Any help you can provide is greatly appreciated!!!!!!
Sincerely, mary trueblood :-)