Showing full pull-down list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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 said:
Okay.....how do I do this without using data validation?
Click to expand...
 
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
 
Back
Top