Jim...

The ListIndex property of a ComboBox returns the currently selected row of the array behind the combo box. So, using your example, you should be able to say

lcOtherColumnValue = MyArray[ComboBoxObject.ListIndex, 02]

Scott


>When you have a combobox with a rowsource using an array, how can you set another variable with the value from the same row number of the array but a different column number after you select an item from the array? Example:
>ARRAY =
>1,A
>2,B
>3,C
>4,D
>5,E
>
>The Combobox selects "D" and after that I want another variable to equal "4". How can you reference the array when it is being selected?
>
>Colombo.