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

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

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

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

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

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