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
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