i want to load data into to a combobox in VBA, however i dont know how to get it like in vb.net where you can specify the value member and the display member.

As i want to load my table ie: mytable(col1,col2) into the combobox and show the values of col2 in the combobox but when the user selects an item i need to get the col1 value of the selected item