Hi Chris.
I have to be overlooking something obvious... I have a combobox with RowSourceType 5-Array, and the included array has 3+ columns. In the combobox.click(), I want call another function and pass columns 2 & 3 as parameters. How do I reference multiple columns from the selected row?If you take John's suggestion, keep in mind that all the items in the control's internal List collection are stored as character strings. If you have other data types in your array, a better solution would be to access the array directly like this:
assuming that the array used as the RowSource is an array property of the combo box called aItems, this code will do it for you:
lnRow = This.ListIndex
CallMyFunction( This.aItems[ lnRow, 2 ], This.aItems[ lnRow, 3 ] )