Using an Index formula to populate a TextBox on a Form

[gheyman]

I have a ComboBox (Combo1) that after a selection is made I want to populate other Textboxes using an Index formula

The names are"
ComboBox = ComboBox1
The Tab where my table is = BuyerID or Sheet10
The table field that I want to pull the data from = Buyer
The Match from selection in ComboBox
Match Field "BuyerID" (Yes, its the same name as the tab)

Private Sub ComboBox1_Change()



TextBox1 = Sheet10.Range("C18").Value

TextBox2 = WorksheetFunction.Index(Range("BuyerID[Buyer]"), WorksheetFunction.Match(ComboBox1, Range("BuyerID[BuyerID]"), 0))

End Sub

not sure what's wrong with the index formula but its not working
Thanks

 

[Fluff]

Glad to help & thanks for the feedback