Populate a textbox on Userform with data from a filtered range using VBA

[newbi004]

Hi

I have a sheet which is filtered and I want to populate textboxes on a userform with data from a selected row of the filtered sheet.

I have identified the RowNo of visible cells I want populating, but the code I have below gives me a 'Could not set the Value property. Type mismatch.' error.

Can someone help me understand what I am doing wrong?

Thanks

Sub PrintData()
    Dim RowNo As Long
    
    RowNo = Sheets("Module Data 2").Range("L2").Value
    With Sheets("Inventory")
    
    txt1.Value = Sheets("Inventory").Cells(1, RowNo).SpecialCells(xlCellTypeVisible).Value
    'TextBox6.Value = .Range("B" & RowNo).SpecialCells(xlCellTypeVisible)
    'TextBox11.Value = .Range("C" & RowNo).SpecialCells(xlCellTypeVisible)

    
    End With
    
End Sub

[AndyLitch]

You don't need to worry about the filter because you can only select the visible rows

Textbox6.value = range("B" & Selection.Row).value
Textbox7.value = range("C" & Selection.Row).value