Combo Box
 

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.

hi,
you need to set more properties.
Go back to the combo box's property sheet.

ColumnCount = 2
ColumnWidth = ? pts; ? pts ( note: 1 inch = 72 pts, 1 cm = 28 pt)
TextColumn = 1 (display left column value in cb when row is selected)
or
Text column = 2 (display right column value in cb when row is selected)

There may be other properties you may wish to set. if so, high light the
property name(on left side) and press F1 to find out what the property does
or is for.
knowing what all the properties are helps you use the control more
effectively.

Regards
FSt1

"arich" wrote:

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.