what is wrong in code
>>> use code - tags <<<
I attach the sample file
>>> use code - tags <<<
Code:
Private Sub CommandButton1_Click()
Me.TextBox1.Value = Application.WorksheetFunction.VLookup(Me.ComboBox1.Value, Sheet2.Range("A2:A8"), Application.WorksheetFunction.Match(Me.ComboBox2.Value, Sheet2.Range("B1:E1"), 0), 0)
End Sub
I attach the sample file
Attachments
Last edited by a moderator: