syntax dependent on values of multiple comboboxes

[Glenn C]

Hi All,

Is anyone able to help me with the below?

I need the values in blue to refer to the result on Combobox17, and the values in red to depend on the result of combobox5




If Sheets("changes dependent on combobox17").Cells(i, "A").Value = (Me.TextBox101) Or _
Sheets("changes dependent on combobox17").Cells(i, "A").Value = Val(Me.TextBox101) Then
Me.TextBox102 = Sheets("changes dependent on combobox17").Cells(i, "Dependent on the value in Combobox5").Value

Thanks

Glenn

 

[Fluff]

How about

Sht = Me.ComboBox17.Value
If Sheets(Sht).Cells(i, "A").Value = (Me.TextBox101) Or _
Sheets(Sht).Cells(i, "A").Value = Val(Me.TextBox101) Then
Me.TextBox102 = Sheets(Sht).Cells(i, Me.ComboBox5.Value).Value