Office-Fragen.de
ListBox1.RowSource: wie formulieren? - Druckversion

+- Office-Fragen.de (https://office-fragen.de)
+-- Forum: Microsoft Office (https://office-fragen.de/forum-1.html)
+--- Forum: Excel (https://office-fragen.de/forum-2.html)
+--- Thema: ListBox1.RowSource: wie formulieren? (/thread-28222.html)



ListBox1.RowSource: wie formulieren? - StefKe - 03.06.2022

Hallo Gemeinde, ich hab wiedermal eine Pfosten vor'm Kopf:

Code:
Sub ListboxFuellen(objForm As Object, strWksName As String)
    Dim lngLastRow As Long
    Dim lngLastColumn As Long
    Dim wksSource As Worksheet
   
    Set wksSource = Worksheets(strWksName)
    lngLastRow = wksSource.Cells(Rows.Count, 1).End(xlUp).Row
    lngLastColumn = wksSource.Cells(1, Columns.Count).End(xlToLeft).Column
   
    With Verein.ListBox2
        .BoundColumn = lngLastColumn
        .ColumnHeads = True
        'falscher Syntax:
        .RowSource = strWksName & "!A2:" & Cells(lngLastRow, lngLastColumn)
        'läuft:
        .RowSource = strWksName & "!A2:F" & lngLastColumn
    End With
End Sub

wie kann in RowSource das "F" ersetzt werden???

Danke - Stefan


RE: ListBox1.RowSource: wie formulieren? - StefKe - 03.06.2022

.RowSource = strWksName & "!A2:" & Cells(lngLastRow, lngLastColumn).Address