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
