Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 2nd 21, 11:04 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2018
Posts: 23
Default Multi-column listbox help

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?

Thanks!

  #2   Report Post  
Old February 3rd 21, 06:37 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2019
Posts: 85
Default Multi-column listbox help

"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


  #3   Report Post  
Old February 3rd 21, 09:26 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2018
Posts: 23
Default Multi-column listbox help

On Wednesday, February 3, 2021 at 10:37:53 AM UTC-7, Peter T wrote:
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...?


Oh, good idea about using labels above the columns. That might work.

And BTW, yes I did see your answer last week about the listbox. I had trouble getting the code to run at first, as it had runtime errors, but making a few adjustments it works nice. Thank you very much!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multi Column Listbox Help Ken Excel Programming 0 December 20th 06 11:23 PM
AddItem with multi-column listBox David Excel Programming 4 October 26th 05 05:51 PM
Multi-Column Listbox properties Otto Moehrbach[_6_] Excel Programming 1 December 5th 04 11:35 PM
populating a multi-column Listbox Tom Ogilvy Excel Programming 3 April 26th 04 08:26 PM
populating a multi-column Listbox Harald Staff Excel Programming 1 April 26th 04 08:26 PM


All times are GMT +1. The time now is 01:49 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017