Skip to Main Content
Excel 2003 VBA Programmer's Reference
book

Excel 2003 VBA Programmer's Reference

by Paul T. Kimmel, Stephen Bullen, John Green, Rob Bovey, Robert Rosenberg
July 2004
Beginner content levelBeginner
1176 pages
27h 45m
English
Wrox
Content preview from Excel 2003 VBA Programmer's Reference

21

Working with Lists

A list of items is a commonly occurring abstraction in the physical world. For example, people make lists of things to do, groceries to buy, stocks to review, places to visit, shows to watch, books to read, and on and on. In this chapter we will explore lists, the relationships lists have with ranges, and how you can publish and share your lists online.

Creating a List

A list is like a range with added features. When you create a list from a range of cells, Excel adds an auto filter list to the top of the list automatically, which permits the list to be sorted and filtered, an insert point, and a resize handle on the bottom-right side of the list which makes it easy to resize the list manually.

Creating a list couldn't be easier. Click anywhere in a contiguous range of cells and press Ctrl+L or select Data images List images Create List and the Create List dialog box (see Figure 21-1) will popup, displaying a reasonably good guess as to the cells that your list will comprise. Check “My list has headers” if the first row of your list represents header information. After you click OK, the list will be created with drop-down filter lists at the top of each column and an insert row at the bottom of each column.

Figure 21-1

Each of the elements described (except for the totals ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel 2007 VBA Programming with XML and ASP

Excel 2007 VBA Programming with XML and ASP

Julitta Korol
Microsoft® Office Excel 2003 Programming Inside Out

Microsoft® Office Excel 2003 Programming Inside Out

Curtis Frye, Wayne S. Freeze, Felicia K. Buckingham
Excel® 2007 VBA Programmer's Reference

Excel® 2007 VBA Programmer's Reference

John Green, Stephen Bullen, Rob Bovey, Michael Alexander
Access™ 2007 VBA Programmer's Reference

Access™ 2007 VBA Programmer's Reference

Teresa Hennig, Rob Cooper, Geoffrey Griffith, Armen Stein

Publisher Resources

ISBN: 9780764556609Purchase book