if anything in listbox select first item, if listbox empty do nothing (listbox in userform

[mcdermott2]

Hello, all,

I have a listbox "Yval_box" that is usually populated with information. When the userform containing Yval_box opens I have set the 1st item in the listbox to be selected with:

Yval_box.Selected(0) = True

What I want is the above code to run only if items appear in the list box.

Thanks!

[Norie]

Perhaps.

If Yval.ListCount > 0 Then
    Yval_box.Selected(0) = True
End If

[mcdermott2]

Thank you, Norie!

.listcount was what I couldn't figure out.


For posterity, I updated Yval.listcount to Yval_box.listcount to get this to work.