building a hierarchy (threeview) with VBA

[shodan]

Hey all,

I think this is a difficult one.

I would like to build a hierarchy in excel using vba which would make it for the users of the spreadsheet much more easy to choose out of a certain list. The hierarchy would exist out 4 levels which are based on a cornertstone.

Is this any clear at all? Does anyone knows if there are good source or maybe scripts on the web which are farely easy to adjust?

Thanks in advance and have a nice weekend !!

 

[sweater_vests_rock]

shodan.

seems like this occurs if you forgot to export the userform or the exported form wasn't exported properly.
http://www.codecomments.com/archive293-2004-6-209661.html

a bit more explanation here
http://www.mrexcel.com/board2/viewt...ghlight=&sid=59f5d999f014eac52c9f891789fb193c

cheers. ben.

 

[shodan]

Ben,

Tx for your help. I used following script to do the export/import:

Sub ImportForm() 
    Dim wbSource As Workbook, wbDestination As Workbook 


    Set wbSource = Workbooks("Book1") 
    Set wbDestination = Workbooks("Book2") 

    wbSource.VBProject.VBComponents("Userform1").Export "C:\temp\Userform1.frm" 

    wbDestination.VBProject.VBComponents.Import "C:\temp\userform1.frm" 

    Kill "C:\temp\userform1.frm" 
    Kill "C:\temp\userform1.frx" 

End Sub

but is still gives me the same error:
Line 2: Property OleObjectBlob in frmTreeView could not be set.


PS: I did selected the treeview via the additional controls.

thanks guys!!