Hello to all!
I want a textbox to be populated from a combobox value. This works fine as long as my data are on the same workbook. I did population with an indexmatch formula.
My data are currently in another workbook (workbookname=Data).
Could somebody help me to refer to it in the below indexmatch code? i mean where exactly to put the workbook after the index..
Thank you very much in advance!

Private Sub ComboBox1_Change()
    Dim res As Variant
    On Error Resume Next
    res = Application.Index(Range("'Sheet1'!$H$2:$T$5000"), _
    Application.Match(ComboBox1.Value, Range( _
    "'Sheet1'!$H$2:$H$5000"), 0), 3)
    TextBox2.Value = res