> Excel 2000
>
[quoted text clipped - 5 lines]
>
> John.
Hi John,
This group deals with Word VBA, not Excel. You are more likely to get an
authoritative reply from Excel experts if you re-post to
microsoft.public.excel.programming.

Signature
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org
John F - 14 Jun 2005 14:26 GMT
I have have exactly the same issue with a word macro.
> > Excel 2000
> >
[quoted text clipped - 11 lines]
> authoritative reply from Excel experts if you re-post to
> microsoft.public.excel.programming.
Jonathan West - 14 Jun 2005 15:02 GMT
>I have have exactly the same issue with a word macro.
So far as I am aware, there is a bug in the UserForm object model. You can
create column headings for a listbox, but there is not means by which those
headings can be populated with any text.
You'll need instead to put labels above the columns.

Signature
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org