How can I make a userform treeview open to the first node everytime its open.Now it open
to last selected node.
How can I make a userform treeview open to the first node everytime its open.Now it open
to last selected node.
Last edited by zplugger; 01-09-2015 at 08:46 AM.
Would it help to post example workbook?
Here is the workbook I trying to make the treeview default to first item on open, maybe someone can see whats wrong.
Thanks Z
the nodes Selected property set to True will select it.
You have interactions going on in your user form that appear to be obsucring the fact the selected node has changed. Not easy or quick to route out the cause though.
Thanks for looking Andy, I will keep trying to find whats going on.
Z
add this to end of userform initialize event
and use this modified event routinePlease Login or Register to view this content.
SelectNode is only called if userform is visible. This appears to allow the selection to work.Please Login or Register to view this content.
Thanks Andy
Working the way I want it too now,just need to work on some other bugs.I'm using this as a add-in but every time I open it I get a blank space on my right click menu?
I don't get the blank spaces using the example file you posted.
I only got the blank spaces when I used the file as a add-in, got that problem fix with some code change in the workbook close event.I'm
able to delete nodes without a problem,but I need to find a way to delete different Library's. The Combo box shows different library's that you
can create,when I delete one I get a out of bounds error and the file doesn't work any more.Maybe a command button to delete a library.
Z
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks