How can I make a drop down box visible within a worksheet?

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
data>validation obviously)
You cannot use autofilter for this


--


Regards,


Peo Sjoblom


"Bonnie" <Bonnie RemoveThis @discussions.microsoft.com> wrote in message
news:A9EDF7AE-394B-4ADA-9FD4-4D12F9EE35E0@microsoft.com...
> 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" <Bonnie RemoveThis @discussions.microsoft.com> wrote in message
>> news:0E634392-60DC-4256-8B34-320B39751AA1@microsoft.com...
>> > 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" <smiles123 RemoveThis @yahoo.com> wrote in message
>> >> > news:631A9566-9624-4C28-843C-77F446FC617D@microsoft.com...
>> >> > > How do you create a combo box in Excel 2007
>> >> > > --
>> >> > > Jenny
>> >> > >
>> >> > >
>> >> > > "Peo Sjoblom" wrote:
>> >> > >
>> >> > >> You can't using data>validation, you can if you use a combobox
>> >> > >> from
>> >> > >> the
>> >> > >> control toolbox
>> >> > >>
>> >> > >>
>> >> > >> --
>> >> > >> Regards,
>> >> > >>
>> >> > >> Peo Sjoblom
>> >> > >>
>> >> > >>
>> >> > >>
>> >> > >> "skittles_golf" <smiles123 RemoveThis @yahoo.com> wrote in message
>> >> > >> news:91806D61-5E51-41E7-A12B-CB4E0ADB133C@microsoft.com...
>> >> > >> >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
>> >> > >>
>> >> > >>
>> >> > >>
>> >> >
>> >> >
>> >> >
>>
>>
>>

How do I lock down the drop down list values so they don't change from the
control box when selecting an entry?

Your tip was spot on - big thxs

"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" <smiles123.TakeThisOut@yahoo.com> wrote in message
> news:631A9566-9624-4C28-843C-77F446FC617D@microsoft.com...
> > How do you create a combo box in Excel 2007
> > --
> > Jenny
> >
> >
> > "Peo Sjoblom" wrote:
> >
> >> You can't using data>validation, you can if you use a combobox from the
> >> control toolbox
> >>
> >>
> >> --
> >> Regards,
> >>
> >> Peo Sjoblom
> >>
> >>
> >>
> >> "skittles_golf" <smiles123.TakeThisOut@yahoo.com> wrote in message
> >> news:91806D61-5E51-41E7-A12B-CB4E0ADB133C@microsoft.com...
> >> >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
> >>
> >>
> >>
>
>
>

Finally- someone who knows what the hell they are saying! BIG thanks from SD:)

"Bonnie" wrote:

> 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" <smiles123 DeleteThis @yahoo.com> wrote in message
> > > news:631A9566-9624-4C28-843C-77F446FC617D@microsoft.com...
> > > > How do you create a combo box in Excel 2007
> > > > --
> > > > Jenny
> > > >
> > > >
> > > > "Peo Sjoblom" wrote:
> > > >
> > > >> You can't using data>validation, you can if you use a combobox from the
> > > >> control toolbox
> > > >>
> > > >>
> > > >> --
> > > >> Regards,
> > > >>
> > > >> Peo Sjoblom
> > > >>
> > > >>
> > > >>
> > > >> "skittles_golf" <smiles123 DeleteThis @yahoo.com> wrote in message
> > > >> news:91806D61-5E51-41E7-A12B-CB4E0ADB133C@microsoft.com...
> > > >> >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
> > > >>
> > > >>
> > > >>
> > >
> > >
> > >

How can you do this is Excel 2003?

"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" <smiles123.TakeThisOut@yahoo.com> wrote in message
> news:631A9566-9624-4C28-843C-77F446FC617D@microsoft.com...
> > How do you create a combo box in Excel 2007
> > --
> > Jenny
> >
> >
> > "Peo Sjoblom" wrote:
> >
> >> You can't using data>validation, you can if you use a combobox from the
> >> control toolbox
> >>
> >>
> >> --
> >> Regards,
> >>
> >> Peo Sjoblom
> >>
> >>
> >>
> >> "skittles_golf" <smiles123.TakeThisOut@yahoo.com> wrote in message
> >> news:91806D61-5E51-41E7-A12B-CB4E0ADB133C@microsoft.com...
> >> >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
> >>
> >>
> >>
>
>
>

View>Toolbars>Control Toolbox

Click on the "Design Mode" Icon and draw your Combobox.

Same instructions after that.


Gord Dibben MS Excel MVP

On Tue, 8 Jul 2008 14:21:00 -0700, Kendra510
<Kendra510.DeleteThis@discussions.microsoft.com> wrote:

>How can you do this is Excel 2003?
>
>"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" <smiles123.DeleteThis@yahoo.com> wrote in message
>> news:631A9566-9624-4C28-843C-77F446FC617D@microsoft.com...
>> > How do you create a combo box in Excel 2007
>> > --
>> > Jenny
>> >
>> >
>> > "Peo Sjoblom" wrote:
>> >
>> >> You can't using data>validation, you can if you use a combobox from the
>> >> control toolbox
>> >>
>> >>
>> >> --
>> >> Regards,
>> >>
>> >> Peo Sjoblom
>> >>
>> >>
>> >>
>> >> "skittles_golf" <smiles123.DeleteThis@yahoo.com> wrote in message
>> >> news:91806D61-5E51-41E7-A12B-CB4E0ADB133C@microsoft.com...
>> >> >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
>> >>
>> >>
>> >>
>>
>>
>>

Peo - you clearly know much more than me. Where is the "Office" button? I
certainly don't see it in my Excel icons...

MD
Boston, MA USA

"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" <smiles123 DeleteThis @yahoo.com> wrote in message
> news:631A9566-9624-4C28-843C-77F446FC617D@microsoft.com...
> > How do you create a combo box in Excel 2007
> > --
> > Jenny
> >
> >
> > "Peo Sjoblom" wrote:
> >
> >> You can't using data>validation, you can if you use a combobox from the
> >> control toolbox
> >>
> >>
> >> --
> >> Regards,
> >>
> >> Peo Sjoblom
> >>
> >>
> >>
> >> "skittles_golf" <smiles123 DeleteThis @yahoo.com> wrote in message
> >> news:91806D61-5E51-41E7-A12B-CB4E0ADB133C@microsoft.com...
> >> >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
> >>
> >>
> >>
>
>
>