The ListObject object displays data in a series of rows and columns. In this topic, you programmatically work with various members of the ListObject object to change the display styles of a table in Microsoft Excel 2010. To complete this task, you must do the following:

In this task, you add a table to a worksheet and then step through the VBA code to see the effects on the display styles of the table.

To step through the code

Drag the Visual Basic Editor window to the right side of your monitor.

Drag the Excel window to the left side of your monitor and adjust the windows until you can see them both.

Now, place the cursor in ListObjectDisplayDemo procedure, press F8 to get started debugging, and then press Shift+F8 to step through the code line-by-line (and bypass external procedures) and watch the code behavior.