Retrieve column values of the selected row of a multicolumn Access listbox Retrieve column values of the selected row of a multicolumn Access listbox vba vba

Retrieve column values of the selected row of a multicolumn Access listbox


Use listboxControl.Column(intColumn,intRow). Both Column and Row are zero-based.


Just a little addition.If you've only selected 1 row then the code below will select the value of a column (index of 4, but 5th column) for the selected row:

me.lstIssues.Column(4)

This saves having to use the ItemsSelected property.

Kristian


For multicolumn listbox extract data from any column of selected row by

 listboxControl.List(listboxControl.ListIndex,col_num)

where col_num is required column ( 0 for first column)