gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,332
- Office Version
- 365
- Platform
- Windows
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)
not sure what's wrong with the index formula but its not working
Thanks
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)
Code:
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