Treeview in VBA in Excel

[The-Farmer]

Is there any way to show the list that I have on a spreadsheet on a TreeView Control using Excel VBA. It is nothing but a list of folders taken from somewhere using the shell command and each folder that is put into 1 column of the Excel. I basically want that structure to be shown on a User form with the appropriate structure maintained...thought it may be possible using Treeview? I have never used Treeview earlier, hence I have no idea how to use it, any pointers will be greatly appreciated.

[Leanne]

You just need to know which node is selected and then remove it.

Private Sub TreeView1_KeyDown(KeyCode As Integer, _
ByVal Shift As Integer)

Dim nodTemp As Node

If KeyCode = vbKeyDelete Then
Set nodTemp = TreeView1.SelectedItem
If MsgBox("Are you sure you want to delete " & _
nodTemp.Text, vbYesNo Or vbQuestion) = vbYes Then
TreeView1.Nodes.Remove nodTemp.Index
End If
End If

End Sub