One play to achieve this ..

A sample construct is available at:
http://cjoint.com/?ldko1w2N2N
Combo box from control toolbox toolbar_Example2.xls
(Link above is good for 14 days)

Assume source data is in Sheet1!A2:B7
where col A = Code Descriptions, col B = Codes
(switch it the other way around, with codes in col B)

Then in say, Sheet2,
Draw a combo box from the control toolbox toolbar
Right-click on the combo box Properties

Set the properties of the combo box to:
ListFillRange: Sheet1!A2:B7
LinkedCell: B2
BoundColumn: 2
ColumnCount: 2
ColumnWidths: 250 pt;60 pt

Click "Exit Design Mode" on the Control Toolbox toolbar, and test it out.
The combo box droplist will display both the code descriptions & codes, while
making a selection will place only the code into the link cell: B2
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Gayla" wrote:
I am not really sure what I need for this trick. After several hours of
searching, I thought I would just ask.
I have a drop down list:
Code Code Description
CL01 Client has not provided the files/data required to complete manual(s)
CL02 Client has not made decision on Programming/Database Management
CL03 Client has not made decision on Particular Subject Matter
CL04 Client out of Office/on vacation
CV01 Server down - unable to retrieve documents
CV02 SME - Out of the Office

I want them to be able to choose which code pertains to their situation so
they need to be able to see all this information. But in the actual cell
where it is chosen I only want the code to populate the cell. The Description
I will have populate on another worksheet. Any suggestions? I have even
attempted using the =LEFT or =RIGHT functions. Keep in mind that I havent
been able to crack open the book "VBA for Dummies" - so please be easy.
Where do you get information to learn VBA anyway? I took Basic Programming
back in the stone ages - but I dont remember any of it. Thanks ahead of time.