Excel DropDownlist change Event Using VBA

Here the articles describes how to handle the worksheet change event using VBA. The Visual Basic Editor is a program within Excel that allows you to communicate with Excel.

How to start VBA in Excel ?

First enable the developer tab in excel 2007 to follow below steps:

1. Open excel 2007 and create new worksheet.
2. In menu , just right Click any of the tab.
3. In that , click 'Customize Quick Access Toolbar'
4. Move to popular section , and click option 'Show develper tab in the ribbon'.
5. Then you find developer tab as like view.
   
   
    
6. Click visualbasic ,select the sheet1 and write and code which as attached in this articles.
   
   
    
7. Select the dropdownlist , it will automatically update into the next sheet through the help of below code.

Private Sub Worksheet_Change(ByVal Target As Range)
<process
End Sub

Securities :

In Excel 2007 to 2010 , use the "Developer" ribbon click on the "Macro Security" button. Check the second level "Disable all Macros with Notification" and you are set.

Conclusion :

With the help of VBA , it is a very user-friendly development environment. VBA procedures developed in the VB Editor and its the part of workbook in which they are developed and saved the VBA components .