"peterDavey" schrieb
Jens,
the following code loads a multi-column list box with the names and number
formats of the data fields of a pivot table. The trick is to load the data
into an array variable first the assign that array to the list box List
property: E.g. Me.lstDataItem.List() = varListArray.

Peter,

thanks a lot for that code snippet.

However, the question is whether it is possible to set column headers with
this method. I.e., the contents of the first row of the array sould be
interpreted as the contents for the column headers.

E.g.:
myArray(0,0) = "Header 1"
myArray(1,0) = 1
myArray(2,0) = 2
myArray(0,1) = "Header 2"
myArray(1,1) = 3
myArray(2,1) = 4

sould turn into the Listbox:
Header 1 Header 2
--------------------
1 3
2 4

Is it possible to achieve something like this?

Thanks again!
Jens