One play to achieve it here would be
to use a combo box from the control toolbox toolbar

Try this sample from my archives which illustrates:
http://savefile.com/files/221672
Combo box from control toolbox toolbar_Example2.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Spiritdancer" wrote:
What do I create if I want to display a list of codes and definitions, but
only want the code to be entered in the cell when selected?
Displayed:
MX Mexico
US United States

When selected, only MX or US should be entered in the cell