list box

  • Thread starter Thread starter Wavequation
  • Start date Start date
W

Wavequation

I have a list box, upon whose selection determines the contents of another
list box. If there is only one value given in the second list box, I would
like it to be automatically selected... any advice?
Thanks!
 
Wavequation said:
I have a list box, upon whose selection determines the contents of another
list box. If there is only one value given in the second list box, I
would
like it to be automatically selected... any advice?
Thanks!
Click to expand...

Let's call them Listbox1 and Listbox2. In Listbox1's AfterUpdate event,
include the following:

If Listbox2.ListCount = 1 Then
Listbox2 = Listbox2.ItemData(0)
End If
 
Back
Top