get value from listbox

[matrixknow]

Hola,

I get the index value form the selected item form my listbox. eg 9.
I should get the literal value of the second column and the
literal value of th fourth column which is not visible (with 0 cm). This is not working.

   Dim strFileName As String
   Dim frm As Form
   Set frm = Forms!F_DAG
      If frmDag!lstShow.ItemsSelected.Count > 0 Then
         Dim intColumns As Integer
         intColumns = frmDag!lstShow.ColumnCount
         MsgBox intColumns = ok
         MsgBox frmDag!lstShow.Value = 9 is not the literal value but the index
      End If
   
   strFileName = [Forms]![F_DAG]![lstShow].Column(4) = not working

 

[matrixknow]

sorry friends, easy problem, I found it while reading some issues on comboboxes on the internet.

The Column index is zero bases. This works

strFileName = [Forms]![F_DAG]![lstShow].Column(3)