Hi,
Take a look to Debra Web it has excellent examples

http://www.contextures.com/xlDataVal02



"KRK" wrote:

Hello,

I want to enter text into a cell, with the text chosen from a limited number
of options (probably listed in a separate sheet). I suspect I need a
'drop-down box' ??. Do I need to write VBA code, or is this built into Excel
?

At this stage all I need is to know how difficult it's going to be .

I have Excell 2007

Thanks

K