I want both the code and corresponding English translation to appear in the
dropdown box. The codes are in col A, and the translations are in col B.
Under Properites, ListFillRange I have entered: Jobs!A2:B200. Only column A
is shown in the dropdown box.

Also, when I select one of the dropdown options I get a VB error with my
"Jobs!A2:B200" displayed in the VB code. Please tell
me what I'm doing wrong. Thanks.