Build Simple Counter using VBA.

Learning Points In this video you will see how to build simple counter using VBA. You can treat as gentle introduction for Learning VBA. While building this we will learn 1- How to open VBA IDE or Coding window? 2- Why to use Text object image as button image instead of Form button present in Developer tab? 3- How to assing a macro or a VBA Sub to button? 4-VBA code to clear or delete content of a range. ====Code used============= 'since we are changing a cell content of SHEET1' 'hence ideally our code should be written in SHEET1 Sub Counter_BtnClk() 'after clicking button counter should increment 'cell A3 value by 1 or next value= Cell A3 value+1 Range("A3").Value = Range("A3").Value + 1 End Sub 'now we also need reset button Sub Reset_BtnClk() Range("A3").ClearContents End Sub ====================================== Websites www.juggle.biz ====================================== -Click below link to subscribe channel and stay tuned with latest uploads.    / @learnyouandme   -Channel link    / @learnyouandme   If liked this video then please subscribe,like and don't forget to click bell icon. Make comment about your views, any suggestion or video topic you like to see. ====================================== You can watch and learn from below videos also. -Learn to record your first excel macro.[HD]    • How to record your first excel macro (auto...   -HOW TO GIVE OR CHANGE MACRO/VBA SHORTCUT KEY [HD]    • How To Give Or Change a Macro/Vba Shortcut...   -VARIOUS WAYS TO RUN VBA OR MACRO    • Various ways to run macro or VBA in Excel ...