Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
When, that is, TV.Visible = False.
Actually, the crash doesn't seem to happen right on the .Clear, but when you try to add a new node to a cleared-while-hidden TV. I'm too embarrassed to say how long it took me to think of this cute but obvious fix: Push TV.Visine, set to True, .Clear, then pop it again. It should all happen fast enough not to see on-screen. *** What about .Nodes.Remove, you ask? Cheerfully fails too, when TV.Invisible. Only it doesn't crash Excel. *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Iterate through treeview nodes | Excel Programming | |||
VBA croaks on Nodes.Clear if TreeView is *not* Visible. | Excel Programming | |||
Adding nodes to treeview | Excel Programming | |||
treeview add nodes | Excel Programming | |||
TreeView: add more than one node to nodes collection | Excel Programming |