"Tatsujin" wrote in message
How can I add items to a multi-column listbox and change the title names
of each column without using references to cells or ranges on the
spreadsheet?

The short answer is you can't.

Workarounds include using labels or a second listbox above the main listbox
for the headers, though if many columns horizontal scrolling is difficult.

If only using 32bit Excel you could use the mscomctl listview, though even
in x32 there can be reference problems when distributing.

There's also a commercial alternative that works in both 32bit and 64bit.

BTW did you see the answer I suggested for your listbox post last week...?

Peter T