ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Strange Excel Bug? (https://www.excelbanter.com/excel-programming/387704-strange-excel-bug.html)

kirkm[_6_]

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


All times are GMT +1. The time now is 04:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com