ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Repost of Listbox Headers (https://www.excelbanter.com/excel-programming/375441-repost-listbox-headers.html)

Mike Milligan

Repost of Listbox Headers
 
For some reason I lost all newsgroup items posted from 10/7 thru 12:51pm
today. One of which was mine....I've tried downloading all and I don't get
anything....

Anyway, here's what I need.

I have a listbox that I populate view VBA. I do not have data in the
spreadsheet so I don't use RowSource. How can I programmatically name the
headers of my listbox?

Mike



Dave Peterson

Repost of Listbox Headers
 
I don't think you can.

Maybe you could put the data into a worksheet, add headers and use the
rowsource.

Or maybe you could get "creative" and add a label above the listbox that
describes the fields.

Mike Milligan wrote:

For some reason I lost all newsgroup items posted from 10/7 thru 12:51pm
today. One of which was mine....I've tried downloading all and I don't get
anything....

Anyway, here's what I need.

I have a listbox that I populate view VBA. I do not have data in the
spreadsheet so I don't use RowSource. How can I programmatically name the
headers of my listbox?

Mike


--

Dave Peterson


All times are GMT +1. The time now is 09:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com