Copying drop-down selection

  • Thread starter Thread starter Connie
  • Start date Start date
C

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
 
Connie said:
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
Click to expand...

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


If the drop-down was in A1, in the 'other cell' you could use
=IF(A1="OV",A1,"")
Click to expand...
This doesn't work because the information isn't typed in
A1, it's selected from a dropdown in A1.
 
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
 
Back
Top