listbox default selection

[reimbursement]

I have multiple listboxes on a userform to get the users input on what to include in a autofilter list. The listboxes allow for multiple selections. Is there a way to set the first item in the list as the default if nothing is selected?

 

[JillT]

Well, maybe this will help ... I have done this in Access by adding this line to the open event of the form containing the listbox. This selects the first row in the list:

Me.LstDescription.Selected(0) = True

Hope this is what you want!

 

[combo]

The ListIndex property sets the list's selection, first item is 0:
[tt]ListBox.ListIndex = 1[/tt]
selects the second value in list box named ListBox.

combo

 

[TonyJollans]

Hi reimbursement,

To expand on the other replies a little. Firstly you need to check whether or not there is a selection and then you can either set the default selection (which seems like overkill) or just use the value you want for your further processing.

If Me![

ListBoxName

].ItemsSelected.Count = 0 Then

YourVar

 = Me![

ListBoxName

].ItemData(0)

' To use the first item

    Me![List0].Selected(0) = True

         ' To select the first item

End If

Enjoy
Tony