Copying drop-down selection

[Connie]

I am working with Excel 2000. What formula would I use to
copy to another cell the selection of a drop-down box,
i.e. the drop-down consists of a blank, then P, then B,
then OV. If a person selects OV from the drop-down, I
would like the OV to appear automatically in another
cell. Is this possible? Thank you. Connie

 

[Paul]

I am working with Excel 2000. What formula would I use to
copy to another cell the selection of a drop-down box,
i.e. the drop-down consists of a blank, then P, then B,
then OV. If a person selects OV from the drop-down, I
would like the OV to appear automatically in another
cell. Is this possible? Thank you. Connie

If the drop-down was in A1, in the 'other cell' you could use
=IF(A1="OV",A1,"")

 

[Connie]

-----Original Message-----


If the drop-down was in A1, in the 'other cell' you could use
=IF(A1="OV",A1,"")

This doesn't work because the information isn't typed in
A1, it's selected from a dropdown in A1.

 

[Guest]

Try this: If you use an Active X listbox, right-click for
Properties and enter desired cell address in the
LinkedCell property. <grin>

gary b