OK, explain to me how you would put a visible dropdown in cell A2, H10 and
I20
using autofilter? The OP said she put multiple dropdown boxes (using
datavalidation obviously)
You cannot use autofilter for this
--
Regards,
Peo Sjoblom
"Bonnie" wrote in message
...
Yes i did and that wasn't the original post .. the original post was that
she
wanted the drop down box to be visible .. not just when she clicked on the
cell she was on. The combo box was an answer to it then someone asked
about
the combo box.
"Peo Sjoblom" wrote:
You might want to check out the original post before you post something
The OP asked
"How do you create a combo box in Excel 2007"
it has nothing to do with autofilter
--
Regards,
Peo Sjoblom
"Bonnie" wrote in message
...
OMG is everyone kidding? all you have to do is click on the cell you
want
to
have the drop down box arrow appear then go to DATA on the menu
toolbar
and
click FILTER then Click AUTO FILTER thats it. also make sure u
highlight
the
information you want to appear in the drop down menu.
"sparrot" wrote:
I am not sure what you mean by "Put the range with your list in the
listfillrange and the cell you want to link to" I got to that part
and
am stumped.
Thanks
"Peo Sjoblom" wrote:
Office button Excel Options, make sure "Show Developer Tab" is
selected.
Click the Developer tab Controls Insert Combobox from the active
x
controls,
right click the drop down and select properties, in that pane that
opens.
Put the range with your list in the
listfillrange and the cell you want to link to. Click the design
mode
button
to get out
of design mode
--
Regards,
Peo Sjoblom
Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)
"skittles_golf" wrote in message
...
How do you create a combo box in Excel 2007
--
Jenny
"Peo Sjoblom" wrote:
You can't using datavalidation, you can if you use a combobox
from
the
control toolbox
--
Regards,
Peo Sjoblom
"skittles_golf" wrote in message
...
I have created several Drop Down boxes in a worksheet but I want
to
make
them
visible so people know there is a drop down box there. Right
now
the
arrow
doesn't show until you click on that cell. Please help I am
not
quite
sure
how to format it so the drop down arrow stays.
--
Jenny