Simple drop down box with text

[Sam W]

I know this is easy for most of you but I'm stumped. I need a drop down boxor a list box that the user can choose a word from. The box will contain several words such as Breakdown, Scheduled Maintenance, Emergency Repair and so on.

Thanks, Sam

 

[Dave Hawley]

Hi Sam

You can use Excels Validation feature for this. Type your words in a list somewhere, say A1:A10, name it any name (I'll use MyList) then select the cell you want the list in and go to Data>Validation choose LIst then type:
=MyList
Set the other pages of the Validation to suit.

 

[gplhl]

On 2002-03-04 13:16, Sam W wrote:
I know this is easy for most of you but I'm stumped. I need a drop down boxor a list box that the user can choose a word from. The box will contain several words such as Breakdown, Scheduled Maintenance, Emergency Repair and so on.

Thanks, Sam

List these in a new sheet, then Highlight the range and type in the Name Box (next to formula bar normally) service or whatever you want to call it.

Create your combo box using the control toolbox, bring up the properties window and in ListFillRange type in:

Sheet2!service

Where Sheet2 is the name of the sheet and service is the named range.

Or instead of using a named range use

A1:A10 whichever is easiest for you.

 

[Sam W]

Hi Dave. I haven't seen you around in a while. It's nice to hear from you again. Thanks for the help.
Sam Wactor