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

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

Use Data Validation. Select "List" from the options and with the Red button
minimise, go to wherever your list is there, select all of it. That's it. In
that cell you get full list to choose from. Copy this format to all cells or
previously select all cells and then go to data validation. Hope this helps

"KRK" wrote in message
...
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