On Oct 17, 2006, at 2:14 PM, Ian R wrote:
On Oct 13, 2006, at 4:35 PM, Terry Ford wrote:
No, but I would look further into the code where you are making
the cells editable. This might be affecting the re-drawing of the
cell contents.
Well, making the cells editable was only part of the workaround to
fix the drawing problem (the rows are "empty" unless they become
ActiveCell, so I put an EditCell command in the loop that populates
the listbox). I'd prefer they not be editable, but that seems to
be the only way to do it.
I'd love to fix this problem for real, but I'm in super-deadline-
mode right now (hence the delayed reply). However, is there a way
to, in code, make none of the cells active? The way the loop
works, I always end up with the last cell still active. ListIndex
= -1 doesn't do it... in fact, ColumnType = TypeNormal doesn't
work. Dunno.
Listbox1.Setfocus should take away the focus from any cell.
Terry
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
