Adding Listview / Additional / ActiveX Control in Excel 2007 VBA

Question :

  How to add listview control in Excel 2007 VBA ?

 

Answer :  

Step 1 : Open Excel Run->Excel-> OK which will open New Excel

Step 2 : Right click on any sheet and Click View Code, which would open VBA Window

Step 3 : Right click on VBA Project  ->Insert -> UserForm , which would create New User Form

Step 4 : Default Toolbox contains only standard controls ,if you want additional / ActiveX controls then    you have add those controls manually

Step 5 : To Add Additional Controls manually select Tools menu->Click Additional Controls.. 

Step 5 : Choose any control that you want. for example select Microsoft ListView Control Version 6.0 and click OK

Step 6 : Now ListView Control is added in Toolbox

Step 7 : Now drag and place listview control in Form.

Step 8 :  Now you can start write your logic, Sample code here

              http://www.dailydoseofexcel.com/archives/2006/12/26/listview/