![]() |
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