Setting Selected Item in ListBox from Code 1

[innmedia]

Hi,

Does anyone know if it is possible to set the selected item in a list box from VBA? I need to display the listbox with a value already selected, instead of having the user make the selection (although it doesn't matter if they change it afterwards)

Thanks!

 

[afryer]

Hi,

Try this in the Form_Load event.

me.myListBox.Selected(1) = true

The value in the selected parameter is between 1 and the number of items in your list box.

Andrew

 

[innmedia]

Thanks!