I have a list box where I populate options, say
and I need to make vba select certain option (ie. say (2) and (4) dynamically)
I have a loop that determines which option should be selected, but I cant seem to use the listbox.Selected(item) property to select specific options with vba. (there is no error, it just doesnt select the options I need it to select) Any Ideas?
For intCounter = 0 To listCounties.ListCount - 1
If (Val(listCounties.ItemData(intCounter)) = Val(countiesRecordSet.Fields(0))) Then
listCounties.Selected(intCounter) = True