RowIndex count match only with visible rows

Hello guys,

I made filtered ComboBox, which is done by using SpecialCells(xlCellTypeVisible), but now I have a problem with data paste. RowIndex, which I use for this, count all rows, not just the filtered rows. Is there a way, how to do something like this:
RowIndex.SpecialCells(xlCellTypeVisible) = Me.ComboBox1.ListIndex ?

Here is the code, which I need to "repair"

Any help you can offer would be hugely appreciated.

Private Sub cmdSave2_Click()
    Dim RowIndex As Long
    RowIndex = Me.ComboBox2.ListIndex + 6
    Dim Status As String
    Status = UserForm1.txtInWarhouse.Value
    If UserForm1.txtInWarhouse.Value = True Then
    Status = "Na skladě"
    Else
    Status = "Poškozeno"
    End If
    
 If Sheets("Položky").Cells(RowIndex, 6).Value = "Na skladě" Or Sheets("Položky").Cells(RowIndex, 6).Value = "Poškozeno" Then
    MsgBox ("Položka je již vrácena"), vbCritical, "Duplicitní vrácení"
    Exit Sub
    End If
    
 If ComboBox2.Value = "" Then
  MsgBox ("Musí být zvolena položka pro vrácení"), vbCritical, "Chybná volba položky"
 Exit Sub
 End If
     With Me
        Sheets("Položky").Cells(RowIndex, 11).Value = .txtComment2.Value
        Sheets("Položky").Cells(RowIndex, 7).Value = ""
        Sheets("Položky").Cells(RowIndex, 6).Value = Status
    Reset_List
    ClearList
    Me.ComboBox2.ListIndex = RowIndex - 6
    MsgBox ("Položka byla úspěšně vrácena"), vbInformation, "Úspěch!"
    txtInWarhouse = True
    End With
End Sub

Re: RowIndex count match only with visible rows

What is the sheet name of the sheet used for the combo box list?
"Položky"

Which sheet column in that sheet is used to populate your combo box list?
Column A and B

Are the values in that column unique?
In the column, which is used to populate my combo box list, yes.

Re: RowIndex count match only with visible rows

The combination is made in this way:

Dim cbRange As Range
    Dim LR As Long
    LR = Range("A" & Rows.Count).End(xlUp).Row
    Me.ComboBox3.Clear
    With ComboBox3
        For Each cbRange In Range("A6:A" & LR).SpecialCells(xlCellTypeVisible)
          .AddItem cbRange.Value
          .List(.ListCount - 1, 1) = cbRange.Offset(0, 1)
        Next cbRange
    End With

I attach a sample workbook, something is in Czech, but I think, that it is OK to understand the code without any problem.

I know, that my code is a mess in this moment, but I want to "clean it" later (or try to clean it)
forum.ozgrid.com/index.php?attachment/73621/

Re: RowIndex count match only with visible rows

I tried to do this, but I got an error on this line:

UserForm1.txtLabel.Text = .Cells(RowIndex, 1)

Re: RowIndex count match only with visible rows

I tried to do every combination, which you wrote, but still error.

With the first two variants I got the error again on this line:

UserForm1.txtLabel.Text = .Cells(RowIndex, 1)

With the second two variants I got the error on the changed line:

RowIndex = Application.Match(ComboBox1.Column(0), Sheets("Položky").Columns(0), 0

I found out, that the first column is in Czech Office "0" too, because the second column is "1".

Do you have any other ideas?

Re: RowIndex count match only with visible rows

The error is in German:
Original:
Laufzeitfehler "1004":
Anwendungs - oder objektdefinierter Fehler
In english:
Run-time error "1004":
Application - or object - defined error

I don't know, what exactly you want from me about the ComboBox3. Can you, please, be more specific?

Re: RowIndex count match only with visible rows

Here it is:
1 Drátek
2 Kabel
3 Pravítko

The main column is the 1st column, the 2nd. column is just an "addition".

I tried every option with the columns (1 or 0), but now I'm getting another error:
Run-Time error "13"

Re: RowIndex count match only with visible rows

I just noticed, when I got this error and hover over the row with RowIndex...The section "ComboBox1.Column(0)" gives the right number, which was chosen. The "RowIndex =" show me "Error 2042.

Re: RowIndex count match only with visible rows

Now it is working, perfect!

Thank you very much for your help!

Just a small question..
I put a date value to the list (from userform), where I have a conditional formatting, but the condition is not used for the value. I need to manually rewrite the date and then the conditional formatting is used.

I mean the column G.

Do you know a reason of this problem?

Re: RowIndex count match only with visible rows

Thank you again, that's it.

Finally everything works.

I can't do this without your help.

Thank you very much again and have a nice day!