Simple drop down box with text

Sam W

New Member
Joined
Feb 18, 2002
Messages
26
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
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
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.
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,205
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top