Excel DropDownlist Change Event Using VBA

This article 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 the menu, just right-click any tab.
  3. In that, click "Customize Quick Access Toolbar"
  4. Move to the popular section and click the option "Show develper tab in the ribbon".
  5. Then you find the developer tab as in the following:

    Clipboard07.jpg
     
  6. Click visualbasic, select the sheet1 and write the code attached in this article.

    excle-dropdownlist-change-events-using-vba.jpg
     
  7. Select the dropdownlist; it will be automatically updated into the next sheet through the help of the following 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.