如何隐藏ComboBox下拉列中的列？-HowtohidecolumnsinaComboBoxdropdown?

I'm building a ComboBox in an Excel userform that gets its rows from an Access table. I want to display several text fields to the user in the dropdown, but the value returned from the ComboBox should be the ID number associated with the row that the user selects (i.e. the ID column is the bound column). But I don't want to show this ID number to the user. Is there a way to hide a column in the ComboBox's dropdown, but still have that column be bound?

我正在Excel用户窗体中构建一个ComboBox，从Access表中获取它的行。我想在下拉列表中向用户显示多个文本字段，但是从ComboBox返回的值应该是与用户选择的行相关联的ID号（即ID列是绑定列）。但我不想向用户显示此ID号。有没有办法在ComboBox的下拉列表中隐藏列，但是仍然要绑定该列？

1 个解决方案