Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Something Strange Happens on My Excel Workbook | Excel Discussion (Misc queries) | |||
Strange Problem in EXCEL | Excel Worksheet Functions | |||
Strange Excel error | Excel Discussion (Misc queries) | |||
Strange Excel Problem | Setting up and Configuration of Excel | |||
Getting a Strange Message from Excel | Excel Programming |