title: How to Get Value of Visible Cell in a Table after Filtering - only working for 1st value
body: <p>I want to get the value of a cell in a filtered table. It only seems to work for the first value, but from there it counts the hidden values as well.</p>
  
  <p>I am trying to get extra information on specific values in a table. It is kind of a step by step filtering process for some requests. A Combo Box is used to select a specific area of interest, which then shows the "title" of all the values within that area in a ListBox. Then, it should be possible to see a detailed description of a request which is selected in the ListBox.</p>
  
  <p>When a request is selected in the ListBox, it uses the index number to find the right row in the table and get the description from there. </p>
  
  <pre><code>Private Sub ListBox1_Click()
  
      Dim tbl As ListObject
      Dim IndexNmr As Integer
  
      ComboValue = ComboBox1.Value
  
     'Store Table Object to a variable and clear all filters
      Set tbl = Worksheets("Data").ListObjects("Tabel1")
      tbl.AutoFilter.ShowAllData
  
      'Filter Table Object based on ComboValue
      tbl.Range.AutoFilter Field:=8, Criteria1:= _
          ComboValue
  
      'Find selected index in List Box
       For x = 0 To ListBox1.ListCount - 1
           If ListBox1.Selected(x) = True Then
               IndexNmr = x + 1
           End If
       Next x
  
       'Find Caption in Table based on the index number
       CaptionString = tbl.DataBodyRange.Columns(10).SpecialCells(xlCellTypeVisible).Cells(IndexNmr).Value
       Label1.Caption = CaptionString
  
  End Sub
  </code></pre>
  
  <p>It only seems to work for the first visible value, which I can produce by:</p>
  
  <pre><code>`CaptionString = tbl.DataBodyRange.Columns(10).SpecialCells(xlCellTypeVisible).Cells(1).Value`
  </code></pre>
  
  <p>But when the IndexNmr is ex. 2, it just takes the next row below the first visible one, even though it is hidden.</p>
  
  <p><a href="https://i.stack.imgur.com/jugA5.png" rel="nofollow noreferrer">An example of the Table data and filtering</a></p>