ExcelBanter - delimiter between two columns

Has nothing to do with delimiters. You have to use the BoundColumn and
TextColumn properties.

Here is what MS Help says:
When the user chooses a row in a multicolumn ListBox or ComboBox, the
BoundColumn property identifies which item from that row to store as the
value of the control. For example, if each row contains 8 items and
BoundColumn is 3, the system stores the information in the third column of
the currently-selected row as the value of the object.

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 sceond column to zero.

Joerg

"clara" wrote in message
...
Hi all,

I have the following data format:

ItemName ItemNum

and I want to display only ItemName in my dropdown control and use ItemNum
as value. What is the delimiter between ItemName and ItemNum?

Clara

--
thank you so much for your help