excel help?

[wannabedamned]

I made a simple spreadsheet at work, with 2 lists in it. Its just to stop us constantly typing the same stuff, we can drop a menu down and select an option.

Anyways, we do sometime get unusual problems, and I'd like the option of "other" within the list. And when you click it, the cell will be blank and allow for text input.

Is this possible?

 

[wonko]

I can't think of an easy way to do this, but it's probably doable with VBA.
Keeping it simpler, would it be possible to have "Other" as the selection and have an adjacent cell for the entered text? A simple IF() could then merge the selection and "Other" text.

 

[Ethermaster]

what you need is data validation

Use this option in excel, I have also attached this example.

https://dl.dropbox.com/u/908850/Wannabe.xlsx