Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange listbox behavior in version 2003 after version 2007
I have a system that has worked fine for years in the several versions of
Excel leading up to the 2007 version. Recently I brought the code up in Excel 2007 to make some small changes and stored it back in the 2003 format which the people that use it have. I was told there two minor format changes that should not cause a problem (it would be nice if the new version told you the actual cells that contain the minor problems). An Active X listbox on a worksheet that worked fine before and still works fine in the new Excel 2007 now has strange behavior in Excel 2003. The underlying listbox works as it did before. Scrolling with the up and down arrow keys or clicking on an item with the mouse results in the same operations being performed as before but the visible aspect of the listbox does not work. Nothing is highlighted in the listbox to start and the selected item does not get highlighted when you scroll or click. When you scroll down past the bottom of the visible portion the last item in the box repeats upwards to fill the listbox and remains. This is very strange. Has anyone else experienced anything like this? -- russ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange listbox behavior in version 2003 after version 2007
Regarding my earlier post €“ I traced the lisbox visible behavior problem to
an Application.ScreenUpdating I had forgotten I had inserted. In Excel 2007 the listbox did visibly change while the cells on the sheet did not. In Excel 2003 both the listbox and the cells on the sheet did not visibly change. I am finding other different behavior in 2007 versus 2003 that I still have not traced down. I suppose this is turning out to be a comment to beware. -- russ "Russ" wrote: I have a system that has worked fine for years in the several versions of Excel leading up to the 2007 version. Recently I brought the code up in Excel 2007 to make some small changes and stored it back in the 2003 format which the people that use it have. I was told there two minor format changes that should not cause a problem (it would be nice if the new version told you the actual cells that contain the minor problems). An Active X listbox on a worksheet that worked fine before and still works fine in the new Excel 2007 now has strange behavior in Excel 2003. The underlying listbox works as it did before. Scrolling with the up and down arrow keys or clicking on an item with the mouse results in the same operations being performed as before but the visible aspect of the listbox does not work. Nothing is highlighted in the listbox to start and the selected item does not get highlighted when you scroll or click. When you scroll down past the bottom of the visible portion the last item in the box repeats upwards to fill the listbox and remains. This is very strange. Has anyone else experienced anything like this? -- russ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I save an Excel 97-2003 version or 2007 version for Mac 200 | Excel Discussion (Misc queries) | |||
Chart from version 2003 to version 2007 | Charts and Charting in Excel | |||
How can I get the same colors from 2003 version to 2007 version? | Excel Discussion (Misc queries) | |||
links between 2007 version files and 97-2003 version files | Links and Linking in Excel | |||
sendkeys "^v" behavior changed with the office 2003 version? | Excel Programming |