drop down1031

[afdmello]

I got a excel sheet in which I saw a figure like combo box of control
toolbar. but it is not. when I right click it . the cell reference box( LHS
of worksheet top where cell reference is there) reads as drop down1031.
This figure has a month drop down list, referenced from somewhere else in
the sheet.

Right clicking it also gives the short cut menu: cut,
copy,paste(greyed)grouping,order,assign macro, format control.

How is this box created???

AFD

 

[afdmello]

oh sorry it is a combo box created from the forms toolbar and I was trying
from the control toolbar.
in the format control dialog box >control : what does input range, cell link
and drop down lines signify???

AFD

 

[Dave Peterson]

It sounds like it's a dropdown from the Forms toolbar.

 

[Dave Peterson]

You can have a range of values that you can use to populate the dropdown. The
cell link returns an index into the dropdown's list.

So if your dropdown's input range is A1:A10 and your cell link is B1, you can
use a formula like this in C1:

=if(b1="","",index(a1:a10,b1))

Try experimenting with the dropdown lines. You'll see what it does.