referencing multiple fields from a list box

B

Ben Armfield

I would like to be able to use the value of the second
field displayed in a list box to peform calculations, but I
haven't been able to find a way to identify any but the
bound field. Any help would be greatly appreciated. Thanks
in advance. Ben Armfield
 
C

chas

Hi Ben,

You can reference the columns in a listbox or combobox by
their relative position. Bear in mind that the columns
start counting from 0 and not 1 as you'd expect.

=ListBoxName.Column(1)

would refer to the 2nd column

hth

chas
 
Top