Developer Tab and visual basic tools

 1. First You need Developer Tab in excel menu bar. If You do not have Developer Tab then follow below steps

File >>> Option >>> Customize Ribbon >>> find Developer under Main Tabs >>> click the check box >>> ok

                                                                             ⇩

Now you will see the developer Tab on your toolbar. When you click on this developer tab, you will see visual basic tools.