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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert Multiple Fields without Dialog closing between each... 0
ASK Field Formatting 1
Unable to display values in 2nd list box from 1st list box selection 2
list or combo box 0
Calculate the median value before a specified list 0
Finding the right style field in VBA 0
Mail Merge - displaying a conditional number of decimals 5
Prompt for a subform text field 2

Top