tree view + comboboxes

[white_flag]

Hello

It is possible to make an treview with comboboxes in excel? via VBA. If Yes can be provide an example. thank you

 

[Norie]

What are you trying to do?

Isn't having comboboxes in a treeview sort of, I don't know how to describe it properly, 'defeating the purpose' of using the treeview?

I've seen it done but it wasn't in Excel/VBA, I think it was .NET or ASP - might even have been on a webpage.

 

[white_flag]

something like this:

http://www.codeproject.com/KB/tree/treecombo.aspx

 

[Norie]

That was actually the site where I originally saw the idea I think, but it was a more recent article.

I don't think you'll be able to replicate that in VBA though, perhaps someone else knows better.

PS I still don't quite understand why that functionality would be needed.

 

[white_flag]

I like to made a sheet with 3 discipline:
1.uno
2.due
3.tre
those are the nodes then I have for eache nodes more options that will be repated
1.uno-----combo (data1)
|-----combo (data2)
|-----combo (data3)
|-----combo (data4)
2.due-----combo (data1)
|-----combo (data2)
|-----combo (data3)
|-----combo (data4)
etc..

and like this I can the user form smaller otherwise I had o make it via TAB controls.

It is understandable?

 

[Norie]

Couldn't you just use a treeview for that?

 

[white_flag]

1.uno-----combo (data1)-50 entry
|-----combo (data2)-50 entry
|-----combo (data3)-etc
|-----combo (data4)-etc
2.due-----combo (data1)
|-----combo (data2)
|-----combo (data3)
|-----combo (data4)

because are too many data that it is why I like too use the combos. but I guess I will skip the treeview. because I did not find something to help me on internet

 

[Norie]

I can see how comboboxes might work with a treeview in this situation but I don't think you'd be able to do it in VBA without some sort of 3rd party control.

Dependent comboboxes, if that's what you are thinking, probably would be a better idea.

 

[white_flag]

off the record:

I have this code in word:

Option Explicit
 
Private Sub UserForm_Initialize()
  With GetObject("D:\ooo.xls")
    ComboBox1.List = .sheets(1).usedrange.Value
    ComboBox2.List = .sheets(1).usedrange.Value
 
    .Close False
  End With
End Sub

it take an raw data from excel and populate an combo. it is possible to take specify column to specify combo?
ex:

ComboBox2.List = .sheets(1).range("A2:A100")

 

[Norie]

Not 100% sure what you mean, you actually seem to be specifying the column, ie A, to populate the combobox with.

Do you have more than one column of data and you want column A in Combobox1, column B in Combobox2 etc?