Hello there all
I have a combobox named cboTest2D. cboTest2 Dwill obtain its data from the a index match function.
The formula itself works flawlessly but having trouble getting to work in a userform combobxo. The closet I've come is:
Dim ReturnVal As Variant
ReturnVal = Evaluate("INDEX(ValidationMenu!B2:DH8,,MATCH(Data,ValidationMenu!B1:DH1,0))")
Me.cboTest2D.List = ReturnVal
but this is resulting in a run time error 381 could not set the list property invalid property array index. The funny thing is I actually got this to work
but for some reason the sheet didnt save.
Could any one perhaps push me in the direction to getting this to work? Thanks for reading.
I have a combobox named cboTest2D. cboTest2 Dwill obtain its data from the a index match function.
The formula itself works flawlessly but having trouble getting to work in a userform combobxo. The closet I've come is:
Dim ReturnVal As Variant
ReturnVal = Evaluate("INDEX(ValidationMenu!B2:DH8,,MATCH(Data,ValidationMenu!B1:DH1,0))")
Me.cboTest2D.List = ReturnVal
but this is resulting in a run time error 381 could not set the list property invalid property array index. The funny thing is I actually got this to work
but for some reason the sheet didnt save.
Could any one perhaps push me in the direction to getting this to work? Thanks for reading.