I have a listbox in my code in which I am trying to select an item with vba to set a varaible equal to that selection. I get a null value. The listbox is popluated and code does select that appropriate item, but still I get null value.
Dim ItemCount As Integer: ItemCount = Group1_List.ListCount
Dim CurrentItem As String
If Group1_List.ListCount <> 0 Then
For ListItem = 0 To ItemCount - 1
Group1_List.Selected(ListItem) = True
CurrentItem = Group1_List.Value