View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kirkm[_6_] kirkm[_6_] is offline
external usenet poster
 
Posts: 156
Default Strange Excel Bug?


In my Private Sub List1_Enter I assign the row source to a
worksheet and a variable - mline - to a particular row in that
sheet. The purpose is, when the listbox opens, to have that line
selected and highlighted.

List1.ListIndex = mLine
List1.Selected(mLine) = True

This works most of the time, but sometimes the selected
row is *not* mline.

To check further, I added this (on the very next line)

frmReports.Caption = mCaption & " " & mLine

This shows the when the wrong line is highlit, mline
does have the right value.

Does anyone know, under what conditions could
Excel - with the code above fail to set the wanted
line to the value of mline ?

Thanks - Kirk