Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 :-) |
#2
|
|||
|
|||
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 :-) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change fonts in drop down list | Excel Discussion (Misc queries) | |||
formatting drop down list | Excel Discussion (Misc queries) | |||
create a drop down list with the source from a different workbook | Excel Discussion (Misc queries) | |||
How do you create a drop down list? | Excel Discussion (Misc queries) | |||
Drop dow list complication | Excel Discussion (Misc queries) |