Help Creating Drop Down List

Rydog · Apr 29th, 2002, 01:16 PM

I am trying to add a drop down button to a cell. The drop down will feed from a list in an other worksheet. I figured out the way to do this using the forms buttons, but, this puts a box over a cell and I cannot link a formula off it. I need an active cell where the drop down only appears when your cursor is on the cell.

I have an example of this which I can copy to another cell, but, cannot figure out how it was done or what list that drop down is referencing?

Thanks

Steve Hartman · Apr 29th, 2002, 01:24 PM

You want Data > Validation. Name the range of the list in your other worksheet and use it as the validation list.

Rydog · Apr 29th, 2002, 01:42 PM

Thanks, I knew it would be easy and spent 4hrs trying to figure it out myself. This board is great

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 29th, 2002, 01:16 PM	#1
Rydog New Member Join Date: Apr 2002 Posts: 2	I am trying to add a drop down button to a cell. The drop down will feed from a list in an other worksheet. I figured out the way to do this using the forms buttons, but, this puts a box over a cell and I cannot link a formula off it. I need an active cell where the drop down only appears when your cursor is on the cell. I have an example of this which I can copy to another cell, but, cannot figure out how it was done or what list that drop down is referencing? Thanks

Apr 29th, 2002, 01:24 PM	#2
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	You want Data > Validation. Name the range of the list in your other worksheet and use it as the validation list.

Apr 29th, 2002, 01:42 PM	#3
Rydog New Member Join Date: Apr 2002 Posts: 2	Thanks, I knew it would be easy and spent 4hrs trying to figure it out myself. This board is great