drop down boxes?

  • Thread starter Thread starter shaunb
  • Start date Start date
S

shaunb

hi.

i have a sheet here which has a drop down box. simple.
however on this drop down box you can search by entering a
letter and it finds all entries as you type and you can
enter your own data into it.

the sheet isnt locked, but i can not select or see anyway
how this was made.

please please, someone out there must know something.

i eagily await your responses.

cheers ta.
 
Got the same problem. I've done this before but the help
isn't helping for nothing. It gives the guidlines to
create a list but I don't know how to create it. And I see
when I right-click in a cell it has Pick from list but I
don't have anything to pick from.

Good luck
 
Shaun,

It sounds like it's a combo box from the Control Toolbox.
Go View -> Toolbars -> Control Toolbox

Also view the Visual Basic toolbar
View -> Toolbars -> Visual Basic

On the VB toolbar you'll find an icon for "Design Mode"
click on it to enter design mode. Now you should be
able to select the combobox.

To build a combo box of your own like this...
Add a combo box to your sheet from the Control Toolbox.
Right click to combo box and choose properties.
Under the ListFillRange property enter your desired range
(ie A1:A20) and under the LinkedCell property enter the
cell you want the picked item to show up in (ie B1).

Theirs a lot more you can do with these combo boxes if
you get into VBA.

Dan E
 
KJI,

Their are three types
Combo Boxes (Control Toolbox Toolbar)
List Box (Forms Toolbar) (it's called a combobox but since
you can't type in it it really isn't)
In Cell Dropdown (Data Validation)

I've given instructions on how to create a Combo Box from
the control toolbox in this thread in response to Shaun's
question.

List Box (Forms Toolbar)
View the Forms Toolbar (View -> Toolbars -> Forms)
Select the Combo box and add it to your sheet.
Right Click and choose Format Control
Under the Control Tab enter an input range (what you want
in the list (ie A1:A20)) and cell link (where you want the
picked item to appear (ie B1)). Note this puts the index of
the picked item into the cell. To get another cell to display
the picked value use =INDEX(A1:A20,B1).

In Cell Dropdown (Data Validation)
Select the cell which you want the dropdown list to appear
in. From the menu choose Data -> Validation. Under the
settings in the allow field choose List. In the Source field
enter the source (ie A1:A20) or type a set of options (ie
Yes, No, Maybe). Hit OK.

Dan E
 
Back
Top