LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
shirley_kee
 
Posts: n/a
Default Add Listbox header using VBA


I have Column A to BH in my excel sheet. I want to display column A, B
,C,E, G and BH in a userform listbox. I've manage to use VBA to add
selected column data into the listbox. My problem is I have no idea how
to create a list header on top of the list box. I try using the additem
but it doesn't work.

My listbox has horizontal scrollbar as the list is too long so I can't
use label to create the list header name

Please help...


--
shirley_kee
------------------------------------------------------------------------
shirley_kee's Profile: http://www.excelforum.com/member.php...o&userid=30384
View this thread: http://www.excelforum.com/showthread...hreadid=556357

 
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
Header Rows and Sort Issue MikeL. Excel Discussion (Misc queries) 1 March 28th 06 12:23 AM
can I use a cell's contents as part of a custom header? NHVP Treasurer Excel Discussion (Misc queries) 1 February 12th 06 03:28 AM
How do I setup a header in Excel that prints only on first page? mikesam7 Excel Discussion (Misc queries) 3 August 24th 05 08:16 PM
how do I permanetly add custom header to excel header list? GARY Excel Discussion (Misc queries) 1 December 15th 04 08:52 PM
Default header in Excel under page set-up Melanie Excel Discussion (Misc queries) 2 December 15th 04 01:37 AM


All times are GMT +1. The time now is 10:04 AM.

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

About Us

"It's about Microsoft Excel"