"Dave Peterson" wrote in message
...
I put it in the code to populate the combobox in the userform_initialize
procedure.

I put the code to return the second column's value in the ok button's click.
All of the code is in the userform module.

I see. And how would I do it if I don't want to use command buttons but
rather automate the process.

I just want the value of the B column to be available so I can put then in
the command 'MP.CurrentPosition = (insert value of B column here)'