Combo Box with 2 colums, not displaying correctly

I have the below code for an AxtiveX combo box, which appears on sheet12.

Please Login or Register  to view this content.

I'm having the following problems:

1. The combo box displays the concatenated value correctly (IG-01 Argon) when I'm in the box, but not after the selection is made. It then only shows the "IG-01" value. What am I doing wrong?
2. The MsgBox is trying to test for the value selected by the user. I've tried 0, 1, and -1 to get the message to fire but it's not. It should fire with "EITHER" the 1st, 2nd, OR 3rd "AddItem" but it's not firing on anyone of the selections. Any ideas?
3. Can the ".AddItem..." and ".List", be written differently or on a single line?

'The "AddItem" and "List...) lines essentially concatenates....

No. You are putting two separate strings in two different columns. Concatenate builds a single new string from multiple fragments.

Please Login or Register  to view this content.

Note that the "&"'s are concatenating the three strings into one. (the " " is also a one character string).