Get row number from dropdownbox(combobox)

[MHammade]

Hello,
I just started VBA one week ago and got stuck in a problem.
I'd like to get the row number from a combobox.
I don't wanna really see what the value is, I just wanna save it as a variable for later use.
The variable is in a worksheet cales FGA in column B.
Thanks in advance.
MY CODE looks like:



DdTyp.RowSource = "ArtikelA"



Private Sub DdTyp_Change()

Dim rownum As Integer
rownum = 2
TDP1 = Worksheets("FGA").Cells(rownum, "C")

End Sub

 

[MHammade]

Dim MyRow As Integer
MyRow = Range(DdTyp.RowSource)(DdTyp.ListIndex + 1).row
solved