[AccessD] "Modern" replacement for CommonDlg

William Benson (VBACreations.Com) vbacreations at gmail.com
Wed Jul 6 23:46:36 CDT 2011

I have this loop which results in my 2nd listbox row being selected every
time and it annoys me. I can't figure out what is causing *any* row to be

Debug Behavior:  
Row 0 added, nothing is selected.
Row 1 added, it gets selected.
Row 2 added, Row 1 stays selected.
Row 3 added, Row 1 stays selected.

      For Each WS In WB.Worksheets
            lstWS.AddItem WS.Name & ";" &

More information about the AccessD mailing list