Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Showing full pull-down list

I have an excel spreadsheet where there is a list of "categories" (currently
only 10 entries, but can grow), and I would like all 10 entries to show in
the pull-down list. It's only showing 8.

There must be a setting somewhere where I can tell Excel to show complete
list or increase the number showing.... isn't there?
--
Thanks,
Diane
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,268
Default Showing full pull-down list

Not if you are using datavalidation


--
Regards,

Peo Sjoblom



"DianeMcP" wrote in message
...
I have an excel spreadsheet where there is a list of "categories"
(currently
only 10 entries, but can grow), and I would like all 10 entries to show in
the pull-down list. It's only showing 8.

There must be a setting somewhere where I can tell Excel to show complete
list or increase the number showing.... isn't there?
--
Thanks,
Diane



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Showing full pull-down list

Okay.....how do I do this without using data validation?

--
Thanks,
Diane


"Peo Sjoblom" wrote:

Not if you are using datavalidation


--
Regards,

Peo Sjoblom



"DianeMcP" wrote in message
...
I have an excel spreadsheet where there is a list of "categories"
(currently
only 10 entries, but can grow), and I would like all 10 entries to show in
the pull-down list. It's only showing 8.

There must be a setting somewhere where I can tell Excel to show complete
list or increase the number showing.... isn't there?
--
Thanks,
Diane




  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,268
Default Showing full pull-down list

Use a combobox from the control toolbox toolbar, drag it to the sheet, right
click it and select properties, there you can select the ListRows (default
is 8 but this is the one that you should change), you can put in the
ListFillRange (same as the list size in the validation list box), you can
set the LinkedCell. Once you are done you need to click the triangle to take
it out of
design mode. Some other neat options are match first letter entry



--
Regards,

Peo Sjoblom


"DianeMcP" wrote in message
...
Okay.....how do I do this without using data validation?

--
Thanks,
Diane


"Peo Sjoblom" wrote:

Not if you are using datavalidation


--
Regards,

Peo Sjoblom



"DianeMcP" wrote in message
...
I have an excel spreadsheet where there is a list of "categories"
(currently
only 10 entries, but can grow), and I would like all 10 entries to show
in
the pull-down list. It's only showing 8.

There must be a setting somewhere where I can tell Excel to show
complete
list or increase the number showing.... isn't there?
--
Thanks,
Diane






  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Showing full pull-down list

I've got the combobox to show in my data sheet, but I've been having a hard
time trying to get my 10 row list into the ListFillRange.

I was using a different sheet within the workbook to list the categories (as
there is a possibility that this will grow). The sheet name is Categories.

What's the syntax that I would use to put in ListFillRange? I've tried
repeating the content of those 10 rows (separated by commas and by
semi-colons). I've tried telling it to go to the Sheet, but maybe the format
of the information I'm putting in is not corect.

I can't find a sample in the help.

Diane

--
Thanks,
Diane


"Peo Sjoblom" wrote:

Use a combobox from the control toolbox toolbar, drag it to the sheet, right
click it and select properties, there you can select the ListRows (default
is 8 but this is the one that you should change), you can put in the
ListFillRange (same as the list size in the validation list box), you can
set the LinkedCell. Once you are done you need to click the triangle to take
it out of
design mode. Some other neat options are match first letter entry



--
Regards,

Peo Sjoblom


"DianeMcP" wrote in message
...
Okay.....how do I do this without using data validation?

--
Thanks,
Diane


"Peo Sjoblom" wrote:

Not if you are using datavalidation


--
Regards,

Peo Sjoblom



"DianeMcP" wrote in message
...
I have an excel spreadsheet where there is a list of "categories"
(currently
only 10 entries, but can grow), and I would like all 10 entries to show
in
the pull-down list. It's only showing 8.

There must be a setting somewhere where I can tell Excel to show
complete
list or increase the number showing.... isn't there?
--
Thanks,
Diane








  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,979
Default Showing full pull-down list

There are instructions here for using a combo box with data validation:

http://www.contextures.com/xlDataVal11.html

DianeMcP wrote:
I've got the combobox to show in my data sheet, but I've been having a hard
time trying to get my 10 row list into the ListFillRange.

I was using a different sheet within the workbook to list the categories (as
there is a possibility that this will grow). The sheet name is Categories.

What's the syntax that I would use to put in ListFillRange? I've tried
repeating the content of those 10 rows (separated by commas and by
semi-colons). I've tried telling it to go to the Sheet, but maybe the format
of the information I'm putting in is not corect.

I can't find a sample in the help.

Diane



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Ho to pull inmormation from a list? Start-Struck Excel Worksheet Functions 1 April 20th 07 04:52 PM
how do i get the full name list in a workbook ? Voyager Excel Worksheet Functions 2 February 9th 07 11:37 AM
Full Down List That Filters IntricateFool Excel Discussion (Misc queries) 0 November 7th 05 09:02 PM
How do I set up a cell with a pull down list? sick and sleepy Excel Discussion (Misc queries) 1 October 24th 05 03:33 AM
Text in cell not showing in full text in cell in exces Excel Discussion (Misc queries) 2 December 23rd 04 10:13 AM


All times are GMT +1. The time now is 06:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"