View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
vqthomf vqthomf is offline
external usenet poster
 
Posts: 104
Default Listbox Headings

Thanks Leith, Do You Know Where I can Find Examples of code so that I can
work it out?.
TIA
Charles

"Leith Ross" wrote:


Hello Charles,

What you are describing is a ListView control. This control is
available in VBA, but you have to add it to the Toolbox. In the VB
Editior select a UserForm in your project. Insert one if you don't have
one. You can remove it when you are done. Click on the Tools icon to
display the toolbox. Click on Tools on the menu bar and select
Additional Controls. Look in the list for Microsoft ListView Control.
You may have more than 1 version. If you plan to have others use your
code, select the oldest version. If it is only for your system use the
newest.

This is a very flexible and robust control. The downside is programming
it can be difficult. The upside is once you know how you may never want
to use anything else.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=487551