Adding references to your VBA project

 

      -          Open your excel spreadsheet and press ALT + F11

-           From the left side (Project Explorer) double click the Sheet 1 link

-          Now select Tools and  then references

-          In the references  - VBA Project window select   example select  “Microsoft HTML Object Library” and “Microsoft Internet Controls” . Then click ok.