drop down1031

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

afdmello - 29 Jul 2007 21:40 GMT

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

Reply to this Message

afdmello - 29 Jul 2007 22:01 GMT

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

>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
[quoted text clipped - 8 lines]
>
> AFD

Reply to this Message

Dave Peterson - 30 Jul 2007 00:31 GMT

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.

> oh sorry it is a combo box created from the forms toolbar and I was trying
> from the control toolbar.
[quoted text clipped - 14 lines]
> >
> > AFD

Signature

Dave Peterson

Reply to this Message

Dave Peterson - 29 Jul 2007 22:03 GMT

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

> 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
[quoted text clipped - 8 lines]
>
> AFD

Signature

Dave Peterson

Reply to this Message

Rate this thread: