To fill a cell, I want the input user to have 7 options in a drop-down
box, plus the potential for them to type whatever they want (as many
letters as they want) if their response isn't listed. Also, in the
drop down box, I want to offer him different text choices, but once he
picks one of the text choices, I want a number to be saved in the cell.
For example, here are the options, followed by the number I'd like to
be recorded in the cell (in parenthesis):

Event (1)
Violation (2)
Decision (3)
Termination (4)
Opportunity (5)
Effect (6)
Pregnancy (7)


I've figured out how to make drop down boxes, but I have no idea how to
allow for the user to type whatever he'd like if he can't find what he
wants in the options, and I'm not sure how to record the number instead
of the text. Finally, how do you enlarge the width of the drop-down box
when your clicking through your options? The box is never any wider
than the cell, and some of my options are full sentences (the ones
above are just the first word of the actual options). I'd prefer not
to make the cell width huge, since I have to do this for multiple cells
and each one would end up being about half the screen. Any advice?

Thanks,
-RiotLoadTime


--
RiotLoadTime
------------------------------------------------------------------------
RiotLoadTime's Profile: http://www.excelforum.com/member.php...o&userid=35956
View this thread: http://www.excelforum.com/showthread...hreadid=567048