Vba – Add header row to listbox

ms-wordvba

I am using listboxes to display data in userforms in word. However I am not able to set header captions or figure out how to make it possible to click on the header to sort by that column.

GUI.Search_ListBox.Clear
GUI.Search_ListBox.ColumnCount = 5 ' Columns
GUI.Search_ListBox.ColumnWidths = "120;80;70;120;300"
GUI.Search_ListBox.ColumnHeads = True
'GUI.Search_ListBox.RowSource = "Hello;gkjfl;hsjgh;hdfjhgkj;fdjghjkdf" 'here it fails!!!

Best Answer

With VBA, simply set the ListBox.ColumnHeads Property to True.

Alternatively, you can also change the setting in the ActiveX control's Properties dialog:

If the button is disabled on the ribbon, you'll have to enter first.

More Information:

ListBox.ColumnHeads Property (Access)

EDIT:

You need to specify the headings in the rowsource:

Column headings are enabled and either field captions, field names, or the first row of data items are used as column headings.

Related Solutions

Vba – Using MS Access and VBA to generate Ms Word Document

Have a look on the following code:

this will create a new word document including header and footer content as well as body content.

NOTE: Don't forget to add reference for Microsoft Word Object

Dim objWord As Word.Application
Dim doc As Word.Document
Dim WordHeaderFooter As HeaderFooter

Set objWord = CreateObject("Word.Application")

With objWord
    .Visible = True

    Set doc = .Documents.Add
    doc.SaveAs CurrentProject.Path & "\TestDoc.doc" 
End With

With objWord.Selection

 .Font.Name = "Trebuchet MS"
 .Font.Size = 16

  .TypeText "Here is an example test line, #" & " - Font size is " & .Font.Size
  .TypeParagraph

    'Add header and footer

    ActiveDocument.Sections(1).Headers(wdHeaderFooterPrimary).Range.Text = "Header"
    ActiveDocument.Sections(1).Footers(wdHeaderFooterPrimary).Range.Text = "Footer"
End With

doc.Save
doc.Activate

vba ms-access ms-word

Android – Cannot call determinedVisibility() – never saw a connection for the pid – Not navigate to the Html page

Have you tried this? In the logcat for that post there is something about BindingManager﹕ Cannot call determinedVisibility() so maybe the suggested solution will help here too?