Refer to Listbox second column

[shiro]

Dear All,
Can we refer to listbox second column,and then transfer
the second column value on the listbox click even.

And Also how to open an excel workbook files through a
cmd button.I usually using hyperlink address but it doesn't
seem cute.

Thank's

 

[Klatuu]

combo and list box columns can be addressed using the columns collection.

Me.MyTextBox = Me.MyListBox.Column(1)

Note that the columns start numbering at 0, so the second column is (1).

You can open an excel workbook with the Shell command. See details in VBA
Help.