How do I add a drop down menu to a spreadsheet?
How do I add a drop down menu to a spreadsheet?
Take a look at Validation in XL Help.
In article <[email protected]>,
"srf1030" <[email protected]> wrote:
> How do I add a drop down menu to a spreadsheet?
I used the validation command, however I want the arrow button to show at all
times. Not just when you move the mouse to that cell. Do you know how to do
that?
"JE McGimpsey" wrote:
> Take a look at Validation in XL Help.
>
> In article <[email protected]>,
> "srf1030" <[email protected]> wrote:
>
> > How do I add a drop down menu to a spreadsheet?
>
There's a combobox (aka dropdown) on the Forms toolbar and a combobox (aka
combobox) on the Control toolbox toolbar.
If you use a dropdown from the Forms toolbar, you can rightclick on it and
choose Format control.
From the Control tab, you can assign the input range of valid values.
(I used a1:a10 of sheet1)
And you can define a linked cell on that control tab, too.
(I used B1 of sheet1.)
This linked cell returns a number into that list--not the value of the dropdown.
So I used this formula in C1 to get the selected item in the dropdown.
=IF(B1="","",INDEX(A1:A10,B1))
=====
If you choose to use a combobox from the control toolbox toolbar, you can
rightclick on the combobox and show its properties.
That's where you choose .linkedcell and .listfillrange (and other stuff,
including .style (fmstyledropdownlist to prevent users from typing anything).)
The linkedcell of this combobox will show the value of the combobox.
==========
ps. I just color the cell with the data|Validation to show that's required for
input.
srf1030 wrote:
>
> How do I add a drop down menu to a spreadsheet?
--
Dave Peterson
It can't. You need to use a combobox for that.
--
HTH
Bob Phillips
"srf1030" <[email protected]> wrote in message
news:[email protected]...
> I used the validation command, however I want the arrow button to show at
all
> times. Not just when you move the mouse to that cell. Do you know how to
do
> that?
>
> "JE McGimpsey" wrote:
>
> > Take a look at Validation in XL Help.
> >
> > In article <[email protected]>,
> > "srf1030" <[email protected]> wrote:
> >
> > > How do I add a drop down menu to a spreadsheet?
> >
Thanks Dave! This was very helpful!!
"Dave Peterson" wrote:
> There's a combobox (aka dropdown) on the Forms toolbar and a combobox (aka
> combobox) on the Control toolbox toolbar.
>
> If you use a dropdown from the Forms toolbar, you can rightclick on it and
> choose Format control.
>
> From the Control tab, you can assign the input range of valid values.
> (I used a1:a10 of sheet1)
>
> And you can define a linked cell on that control tab, too.
> (I used B1 of sheet1.)
>
> This linked cell returns a number into that list--not the value of the dropdown.
>
> So I used this formula in C1 to get the selected item in the dropdown.
> =IF(B1="","",INDEX(A1:A10,B1))
>
> =====
> If you choose to use a combobox from the control toolbox toolbar, you can
> rightclick on the combobox and show its properties.
>
> That's where you choose .linkedcell and .listfillrange (and other stuff,
> including .style (fmstyledropdownlist to prevent users from typing anything).)
>
> The linkedcell of this combobox will show the value of the combobox.
>
> ==========
> ps. I just color the cell with the data|Validation to show that's required for
> input.
>
>
>
>
>
> srf1030 wrote:
> >
> > How do I add a drop down menu to a spreadsheet?
>
> --
>
> Dave Peterson
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks