I am trying to make a drop down list that displays clear english deffinitions
but when it is printed it prints out a code that is assosiated with the
deffinition.
So it would look something like this:
DOP Date of Packaging
DOR Date of Receipt
DOS Date of Shipment
DOT Date of Q.A. Test Acceptance


When "Date of Packaging" is selected it is displayed on the computer but
when you print "DOP" would show up in its place. This list is stored in a
seperate worksheet, if that matters. I know this is possible because I
already have some that work but they were made in v2003 not v2007, I tried
copying one that works but that ended up not working.