Help!

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

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Worksheet Functions RSS
Next:  Populating cells: Working in multiple worksheets  
Author Message
skittles_golf
External


Since: Apr 25, 2007
Posts: 2



PostPosted: Wed Apr 25, 2007 6:16 pm    Post subject: How can I make a drop down box visible within a worksheet?
Archived from groups: microsoft>public>excel>worksheet>functions (more info?)

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
Back to top
Peo Sjoblom
External


Since: Sep 15, 2003
Posts: 2970



PostPosted: Wed Apr 25, 2007 6:34 pm    Post subject: Re: How can I make a drop down box visible within a worksheet? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

You can't using data>validation, 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
Back to top
skittles_golf
External


Since: Apr 25, 2007
Posts: 2



PostPosted: Wed Apr 25, 2007 7:16 pm    Post subject: Re: How can I make a drop down box visible within a worksheet? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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" 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
>
>
>
Back to top
Peo Sjoblom
External


Since: Mar 21, 2006
Posts: 779



PostPosted: Thu Apr 26, 2007 12:36 am    Post subject: Re: How can I make a drop down box visible within a worksheet? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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 data>validation, 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
>>
>>
>>
Back to top
ramesh
External


Since: Oct 27, 2004
Posts: 5



PostPosted: Wed Jul 29, 2009 2:11 am    Post subject: RE: How can I make a drop down box visible within a worksheet? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

"skittles_golf" wrote:

> 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
Back to top
Ashish Mittal
External


Since: Oct 19, 2009
Posts: 1



PostPosted: Tue Oct 20, 2009 3:28 am    Post subject: Re: How can I make a drop down box visible within a worksheet? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

"Kendra510" 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" wrote in message
> >
> > > 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" 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


I am considering that the learner is asking as to how can he / she get a
drop down visible in an Excel sheet column.

MS Office 2003:

Launch MS Excel 2003
Go to View -> Toolbars -> Control Toolbox
A tool panel shall open displaying all the control options.
Toggle to Sheet2 and key in the entries in a column which you want in
DropDown.
(Say Names of the months from A1:A12)
Select A1 to A12 -> At Top Left corner where you can see A1 written -> Type
Months -> Press Enter Key.
Toggle back to Sheet1 and select 6th button (Combo Box) from Control Toolbox
Panel.
It will turn the mouse cursor in a hairline cross.
Draw a Drop Down Button of the length and width of your choice.
Right click on the created Drop Down Button and select Properties button.
Fill in ListFillRange as Months (This is the name you have given in Sheet2
for the A1:A12)
Close the properties dialog Box
Now in the in Control ToolBox, Press the very first button named "Exit Deign
Mode"
And there you go..... A drop Down with the name of the Months is ready for
you.
You may do experiments for Radio Buttons and other controls too.
Back to top
Parm
External


Since: Oct 24, 2009
Posts: 1



PostPosted: Sat Oct 24, 2009 8:12 am    Post subject: Re: How can I make a drop down box visible within a worksheet? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
> 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" wrote in message
> >> > >
> >> > > > 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" 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
> >> > > >>
> >> > > >>
> >> > > >>
> >> > >
> >> > >
> >> > >
>
>
Back to top
Gord Dibben
External


Since: Feb 23, 2004
Posts: 9431



PostPosted: Sat Oct 24, 2009 1:02 pm    Post subject: Re: How can I make a drop down box visible within a worksheet? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
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
>> 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" wrote in message
>> >> > >
>> >> > > > 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" 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
>> >> > > >>
>> >> > > >>
>> >> > > >>
>> >> > >
>> >> > >
>> >> > >
>>
>>
Back to top
LP
External


Since: Mar 22, 2007
Posts: 2



PostPosted: Tue Feb 02, 2010 6:10 am    Post subject: Re: How can I make a drop down box visible within a worksheet? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Worked for me!
Thanks

"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" wrote in message
> > >
> > > > 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" 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
> > > >>
> > > >>
> > > >>
> > >
> > >
> > >
Back to top
green eyes
External


Since: Apr 23, 2010
Posts: 1



PostPosted: Fri Apr 23, 2010 12:05 pm    Post subject: Re: How can I make a drop down box visible within a worksheet? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

this was VERY helpful!!! Please ignore further instruction below because
everything below is actually more confusing...and Bonnie, you're method is
elementary and doesn't address the question

"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 data>validation, 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
> >>
> >>
> >>
>
>
>
Back to top
Cheers and Beers
External


Since: May 19, 2010
Posts: 1



PostPosted: Wed May 19, 2010 3:43 pm    Post subject: RE: How can I make a drop down box visible within a worksheet? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Here is how you would create a dropdown that is visible in the sheet (like a
form used for expense claims - don't ask teckies how to do real work!).

- Click on the Windows button (top left corner)
- Click on "Excel Options" button near the bottom of the drop down menu.
- Click on the third check box (default unselected) "Always show developer
tab in ribbon", then click Okay (Might as well leave it on, useful if your
doing this often Jenny)
- Click on the "Developer" tab, the click on "Insert", and under "FORM
CONTROLS" (Not Active X)
- Click and drag the box to the desired size and location.
- Right click on the box, and select "Format Control"
- In the new pop-up box, enter the cell range in the "Input range" column.
(Just like in 2003), then click ok.

Hope this helps; Sad it took a Canadian accountant to figure this out!

Cheers.
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Worksheet Functions All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum