ListBox

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
 
D

Dan Artuso

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.
 

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

Top