ListBox

  • Thread starter Thread starter LC
  • Start date Start date
L

LC

Hi,

When an item in a listbox is double-clicked, how can I
refer to that item and its column values?

example of listbox:
lastname firstname age (heading)
green tom 26
brown ale 20
char ally 40

If I double clicked on the row with brown ale, I want to
refer to the lastname, firstname, age of the double-click
item in VBA

something like forms!form1!list1 ....

Thank you,
LC
 
Hi,
You can use the Column property to refer to any column you like.
Me.list1.column(0)
will give you the 1st column, (1) the 2nd and so on.
 
Back
Top