Excel DropDownlist Change Event Using VBA

How to start VBA in Excel?

First, enable the developer tab in Excel 2007 to follow the below steps.

  1. Open Excel 2007 and create a 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 developer tab in the ribbon".
  5. Then you find the developer tab in the following.
    Clipboard07.jpg
  6. Click Visualbasic, select sheet 1, and write the code attached to this article.
    excle-dropdownlist-change-events-using-vba.jpg
  7. Select the dropdown list; it will be automatically updated into the next sheet with the help of the following code.
    Private Sub Worksheet_Change(ByVal Target As Range)
        ' Your code processing here
    End Sub
    

Note. 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.


Recommended Free Ebook
Similar Articles