|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
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@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@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@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@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
>> >> > >>
>> >> > >>
>> >> > >>
>> >> >
>> >> >
>> >> >
>>
>>
>>
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
 Reply |
| |
 |
|
 Top |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
DV dropdowns will not autocomplete.
If you use a combobox with DV per Debra's instructions from the site posted
below you can have autocomplete as well as the arrows showing at all times.
http://www.contextures.on.ca/xlDataVal10.html
Gord
On Sat, 24 Oct 2009 04:12:01 -0700, Parm <Parm@discussions.microsoft.com>
wrote:
>Hi
>
>interesting discussion and helpful. takin git one step further is it
>posssible to auto complete items in a drop down list by for eample typing the
>first few letters. THis wuld avoid haveing to use the mouse.
>
>Any help greatly appreciated
>
>"Gord Dibben" wrote:
>
>> Cameron
>>
>> The method posted by Bonnie has nothing to do with Data Validation dropdowns
>> or Comboboxes.
>>
>> Stick with Peo's suggestion.
>>
>> Go to Debra Dalgleish's site for instructions on using a combobox in
>> conjunction with a DV list.
>>
>> http://www.contextures.on.ca/xlDataVal10.html
>>
>>
>> Gord Dibben MS Excel MVP
>>
>> On Mon, 22 Sep 2008 16:22:01 -0700, Cameron
>> <Cameron@discussions.microsoft.com> wrote:
>>
>> >I just get an error when I try to click FILTER. I am using 2007.
>> >
>> >"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@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@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
>> >> > > >>
>> >> > > >>
>> >> > > >>
>> >> > >
>> >> > >
>> >> > >
>>
>>
.
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
Question
Answer
Notify me of replies