Is there a better/easier way to use the content of the current selection in an extended list box?
Do I have to use the .Selected(varItem) type of method:
Dim varItm As Variant
For Each varItem In Me.LstTables.ItemsSelected
Me.TxtField = Me.LstTables.Selected(varItem)
Next varItem
Or is there a way to use the content of the current selection like this:
Me.TxtField = Me.LstTables.Selection(Current)
Do I have to use the .Selected(varItem) type of method:
Dim varItm As Variant
For Each varItem In Me.LstTables.ItemsSelected
Me.TxtField = Me.LstTables.Selected(varItem)
Next varItem
Or is there a way to use the content of the current selection like this:
Me.TxtField = Me.LstTables.Selection(Current)