View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] k.satish5@gmail.com is offline
external usenet poster
 
Posts: 1
Default TreeView in Excel VBA

Is there any way to show the list that I have on a spreadsheet (see
image) on a TreeView Control using Excel VBA?

http://img135.imageshack.us/img135/6...enprintiv2.png

It is nothing but a list of folders gotten from somewhere using the
shell command and each folder 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.

Thanks much!
Satish