Treeview - How to determine top visible row?

[Gary McMaster]

Hi Everyone,

I have a treeview control displaying the parent / child relationships of a couple of columns. The scroll bar is enabled for the longer lists. If the user scrolls down the tree, is there a way I can tell which node is displayed at the top of the treeview window?

The ultimate goal is to sync the treeview with a listview control. Am I already headed down the wrong path?

I know of the multi column treeview at VbAccelerator but would rather not use a 3rd party control if I can avoid it.

Thanks in adavance for your help.

Gary

 

[Norie]

Gary

Why do you need to work out that particular node?

If the user has drilldown to a particular child node you should be able to go backwards to get the parent nodes.

If it's the parent node you are interested in of course.

 

[Gary McMaster]

Hi Norie,

My plan may not be practical. There are 10 or 12 other fields associated with each node that I intend to display in an adjacent listview control. If the user scrolls either control then I need to scroll the other control to match to keep the rows aligned.

I've been studying the methods and properties of the treeview all day and haven't seen anything that I recognized as a means of determining what is currently visible to the user inside the boundaries of the control.

If I can overcome the resistance to using 3rd party (read Non-Microsoft) controls, I may be able to use the perfect solution which is located here:

http://www.vbaccelerator.com/home/v...iew/Multi-Column_TreeView_Control/article.asp

Thanks for the reply.

Gary

 

[Krishnakumar]

Hi,

This might be a useful one.

 

[Gary McMaster]

Thanks Kris.

The article mentions a version for pre XL2007. Do you happen to know where I could find a copy of the earlier version. I don't have XL2007 available here.

Gary

 

[Krishnakumar]

Hi Gary,

It's there. Check again.

 

[Gary McMaster]

Got it. Thank you!

Gary

 

[Norie]

Gary

As far as I can work out there is no way to get the first visible node of a treeview.

There is GetVisibleCount but that's all you get - a count.

I'm not even sure what's being counted - when I try it with 3 unexpanded top/parent nodes the result isn't 3.

Even when you expand a node the count doesn't seem to change.

The count actually seems to be based on the height of the treeview.

Of course, I might be missing something.

 

[Gary McMaster]

Norie,

I've tried the "GetVisibleCount" myself. It seems to work as advertised but it doesn't do anything for me unless I know which node is the first or last member of that "VisibleCount".

There is also an "EnsureVisible" method. I haven't tried it yet, but my first impression is that you might be able to figure it out by forcing the first and/or last node visible (Ensurevisible) and taking the "VisibleCount" into consideration with a little math. Seems that would cause some serious screen flicker though. Perhaps the control also lets you turn off "Screenupdating".

I've also seen mention of binding the "SelectedItem" property of the two controls together to sync them. Just buzzwords to me at the moment but I'm working on it.

Thanks for your interest.

Gary

 

[Norie]

Gary

As far as I can work out, and I did some light checking, the GetVisibleCount is based on the height of the control.

Even with all the nodes expanded it doesn't change.

Don't know about 'binding' the controls together but you could probably use the SelectedItem from the treeview to change what's in the listview.