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.