Combo Box Display Property

[Meli602]

I have a combo box (control toolbox) that references a range. I have the properties set to only show 2 of the 4 columns and the bound property set to the data I need to pull. When I use the drop down I see the data I want, but when I select an employee only thier emp id remains displayed. What property do I need to change to retain the data displayed in the list.

Attached is a sample version with same set properties

[ratcat]

G'day,

This is the way I would do it.

On Sheet2 I would use col A has a helper col and insert this formula

Please Login or Register  to view this content.

Then change your properties setting in the combo box that reference the range of col A.

Anywho......I feel like your double up on information here. Have you considered a data validation. Another form of a drop down box and using the information in Col A direct to the cell at Sheet 1 B5

Data Validation basic info

HTH

[Meli602]

I'm using a combo box because I'm activating a macro once the employee is selected. I also need to keep the employee id separate so I can use it as a unique identifier for other vlookup formulas in the full report. I have the whole thing set up perfectly except for the way the selection is displayed, driving me a little crazy

[Leith Ross]

Hello Melli602,

This should help you understand what is going on.

From the VBA Help Files

You can display one set of data to users but store different, associated values for the object by using the BoundColumn and the TextColumn properties. TextColumn identifies the column of data displayed in text box portion of a ComboBox and the value stored in the Text property; BoundColumn identifies the column of associated data values stored for the control. For example, you could set up a multicolumn ListBox that contains the names of holidays in one column and dates for the holidays in a second column. To present the holiday names to users, specify the first column as the TextColumn. To store the dates of the holidays, specify the second column as the BoundColumn. To hide the dates of the holidays, set the ColumnWidths property of the second column to zero.

Sincerely,
Leith Ross