"Katie" wrote:
I would like a drop-down in the box to say "Red, Yellow, Blue"
but then I would like the text in the box to be "R, Y or B". Is this possible?

One play to achieve it 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
---